Re: Random Unique ID

At 4:53 PM +0100 3/22/07, Németh Zoltán wrote:

2007. 03. 22, csütörtök keltezéssel 11.42-kor tedd ezt írta: As for efficiency, that's probably not even worth mentioning in this case. why not? you would use 2 sql queries while I would use one most of the time and 2 in case of already reserved ID - that is almost twice as much processor time that may count much if the routine is used frequently

Go ahead, try it, and tell me how much time it cost. From experience, there are things one can spend their time optimizing and there are other things that one should be able to see that aren't worth pursing. I've been wrong before, but you're open to prove me wrong again, if you like. Cheers, tedd -- ------- http://sperling.com http://ancientstones.com http://earthstones.com