Subject Data Type for Primary Key
Author Kevin Meyers
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