This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi, As LightSpeed-managed database grows, so does the automatic ID that all new records get. It is managed in the KeyTable table, stored under the column named NextId. However, it's a 32-bit integer, which means that the DB cannot contain more than 2.1B records under LightSpeed. Is there a way to use a 64-bit automatic ID instead in order to effectively remove this limitation? Thanks! |
|
|
|
|
Hi, Yes - you just need to use an Int64 identifier type on your entities and ensure that the KeyTable is using a bigint. That will use a 64 bit number. I hope that helps, John-Daniel Trask |
|
|
|
