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
|
As I understand, there is no way to specify different block size for different sequences? In my situation I have nearly one specific Sequence for one table in Oracle, that easy realized with NamingStrategy.GetMultiSequenceName(). But it is not appropriate for all situation to have constant IdentityBlockSize (Increment By in Oracle). For one table it must be 100 for another 10. Is it possible to specify IdentityBlockSize independently for each specific Sequence? Sincerely, Konstantin. |
|
|
Thats correct, we only maintain a single IdentityBlockSize per context however if your sequence returns a smaller block size than the IdentityBlockSize we will continue to make calls until the identity block we need to reserve is met. If the sequence returns a larger number than we expect then the remainder will be ignored since the block we need is satisfied, so for example you could use a block size of 10 and have it work with all sequences, equally you could use a block size of 100 although this will cause 10 database calls to fill a block for sequences with an increment by of 10 so that is not very desirable! Using a block size equal to the smallest increment by value (presumably this is 10?) should cover things and keep the number of database calls to a minimum - can you see any major problems with this?
|
|
|
Hello Jeremy, OK, I see your point of view. It will be nice, if you include an above explanation in Users Guide of LightSpeed. Thanks. |
|