db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel Noll <dan...@nuix.com.au>
Subject Re: "generated by default" question
Date Thu, 15 Jun 2006 23:38:30 GMT
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 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.

View raw message