firebird-support - Data Type for Primary Key

Subject	Data Type for Primary Key
Author	Kevin Meyers
Post date	2015-10-06T20:36:57Z

I am wondering if any of you have every noticed any significant performance difference between using BIGINT versus INTEGER as an autoincremented primary key in Firebird. My idea is to use BIGINT and have virtually unlimited records ("set it and forget it" approach), but if I am going to incur a real performance hit, I would probably use INTEGER instead. I've done some modest testing and haven't noticed much difference, but I am wondering what you all have experienced in real world situations.

Thanks in advance,

Kevin