You should have an index.
--- On Sun, 10/19/08, Amir Michail <[EMAIL PROTECTED]> wrote: > From: Amir Michail <[EMAIL PROTECTED]> > Subject: Re: Most efficient way to get max row id? > To: "Derby Discussion" <[email protected]> > Date: Sunday, October 19, 2008, 9:18 PM > On Mon, Oct 20, 2008 at 12:15 AM, Amir Michail > <[EMAIL PROTECTED]> wrote: > > On Sun, Oct 19, 2008 at 11:25 PM, Kai Ponte > <[EMAIL PROTECTED]> wrote: > >> On Sunday 19 October 2008 02:04:29 pm Amir Michail > wrote: > >>> On Sun, Oct 19, 2008 at 5:00 PM, Peter > Ondruška > >>> > >>> <[EMAIL PROTECTED]> wrote: > >>> > You want to use identity: Defining an > identity column > >>> > >>> Yes, but how do you get the max row id > efficiently without adding another > >>> row? > >> > >> In the particular table, how many rows are you > referring to? A few thousand? A > >> few million? A hundred million? > >> > >> Do you have an index on the identity column? > What's your datatype? > > > > ~60,000 rows > > But there's also a where in the query, so the number of > rows > considered by max will vary. A slow case involves ~ 16000 > rows. > > Amir > > > > > So if I put an index on the identity column, max will > be fast? > > > > Amir > > > >> > >> -- > >> kai > >> www.filesite.org || www.perfectreign.com > >> > >> > >> Clean out a corner of your mind and creativity > will instantly fill it. - Dee > >> Hock > >> > > > > > > > > -- > > http://chatbotgame.com > > http://numbrosia.com > > http://twitter.com/amichail > > > > > > -- > http://chatbotgame.com > http://numbrosia.com > http://twitter.com/amichail __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
