Michael Segel wrote:
Uhm,
I'm sorry, but where did I ever say 'select max()'?
Hint: I didn't because its not that efficient.
Presumably he column would be indexed if you're doing operations like
max() on it anyway, so efficiency isn't the problem. I suspect the
problem would be what to do when two users tried to insert rows at
around the same time. The second would fail to commit the transaction
and have to try again.
Daniel
--
Daniel Noll
Nuix Pty Ltd
Suite 79, 89 Jones St, Ultimo NSW 2007, Australia Ph: +61 2 9280 0699
Web: http://www.nuix.com.au/ Fax: +61 2 9212 6902
This message is intended only for the named recipient. If you are not
the intended recipient you are notified that disclosing, copying,
distributing or taking any action in reliance on the contents of this
message or attachment is strictly prohibited.
