Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (asf.osuosl.org: local policy)
Message-ID: <4491EF76.4030506@nuix.com.au>
Date: Fri, 16 Jun 2006 09:38:30 +1000
From: Daniel Noll <daniel@nuix.com.au>
Organization: NUIX Pty Limited
User-Agent: Thunderbird 1.5.0.4 (Windows/20060516)
MIME-Version: 1.0
To: Derby Discussion <derby-user@db.apache.org>
Subject: Re: "generated by default" question
References: <20060615211351.5D69B25150@dbrack01.segel.com>
In-Reply-To: <20060615211351.5D69B25150@dbrack01.segel.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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.