Are sequential technical keys a performance problem?
In some databases, like Sybase, where data is stored in primary key order, sequential technical keys can cause problems on insert as all new data is always added into the same area of the index. This can slow inserts as users doing simultaneous updates to the same table will be processed serially. To avoid this problem, one user suggested a technical key that is the combination of a random number, a sequential number, and the current year!
Related Questions
- If you have a problem of a more technical nature involving the performance or specifications of a product then please contact Technical Services FREEPHONE 0800 27 25 72 or by Email: eurtechserv@sial.com . Can I request courier delivery and what is the cost?
- Are sequential technical keys a performance problem?
- Still need to report a technical problem?
