Bert, Thanks a lot for this unexpectedly quick response :)
Ali Sadik Kumlali --- Bert Verhees <[EMAIL PROTECTED]> wrote: > Ali Sadik Kumlali wrote: > > >Hello, > > > >I am working with approximately 3.5 million rows data. As far as I > >see count(*) is very slow comparing with max(rowid). > > > >I wonder if I could use max(rowid) safely instead of count(*). Does > >rowid increments by 1 for each new row? > > > >Thanks a lot. > > > >Ali Sadik Kumlali > > > >__________________________________ > >Do you Yahoo!? > >Yahoo! Finance Tax Center - File online. File on time. > >http://taxes.yahoo.com/filing.html > > > >--------------------------------------------------------------------- > >To unsubscribe, e-mail: [EMAIL PROTECTED] > >For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > When you delete a row in between the rowid's will not be decremented, > so > it is only save when you never delete a row > > Bert Verhees __________________________________ Do you Yahoo!? Yahoo! Finance Tax Center - File online. File on time. http://taxes.yahoo.com/filing.html --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
