2006/3/24, Zabach, Elke <[EMAIL PROTECTED]>: > Your argument with the special number intervals I do not understand. > Do you mean, not just 1 more or 9 times 1 more and the 10th time 20 more > or what is the problem with sequences? In your update example we do not > see that problem, just add 1. > Hope you checked sequences very well because your private 'sequence' > costs performance compared to those of the database.
At first I had that similar thought. I think what he means by special numbering is that he has a counter per key (string). If I understood his SQL correctly then he uses a table to implement n counters (or sequences if you like). Cheers robert -- Have a look: http://www.flickr.com/photos/fussel-foto/ -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]