Subject: Re: [sqlite] Is using max(rowid) instead of
count(*) safe? - msg#00329

Previous Message by Date:

[sqlite] Is using max(rowid) instead of count(*) safe?

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: sqlite-users-unsubscribe-CzDROfG0BjIdnm+yROfE0A@xxxxxxxxxxxxxxxx For additional commands, e-mail: sqlite-users-help-CzDROfG0BjIdnm+yROfE0A@xxxxxxxxxxxxxxxx

Next Message by Date:

Re: [sqlite] Is using max(rowid) instead of count(*) safe?

Bert, Thanks a lot for this unexpectedly quick response :) Ali Sadik Kumlali --- Bert Verhees <bert.verhees-OjSWxgR8lhI@xxxxxxxxxxxxxxxx> 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: > >sqlite-users-unsubscribe-CzDROfG0BjIdnm+yROfE0A@xxxxxxxxxxxxxxxx > >For additional commands, e-mail: > >sqlite-users-help-CzDROfG0BjIdnm+yROfE0A@xxxxxxxxxxxxxxxx > > > > > > > > > > > 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: sqlite-users-unsubscribe-CzDROfG0BjIdnm+yROfE0A@xxxxxxxxxxxxxxxx For additional commands, e-mail: sqlite-users-help-CzDROfG0BjIdnm+yROfE0A@xxxxxxxxxxxxxxxx

Previous Message by Thread:

[sqlite] Is using max(rowid) instead of count(*) safe?

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: sqlite-users-unsubscribe-CzDROfG0BjIdnm+yROfE0A@xxxxxxxxxxxxxxxx For additional commands, e-mail: sqlite-users-help-CzDROfG0BjIdnm+yROfE0A@xxxxxxxxxxxxxxxx

Next Message by Thread:

Re: [sqlite] Is using max(rowid) instead of count(*) safe?

Bert, Thanks a lot for this unexpectedly quick response :) Ali Sadik Kumlali --- Bert Verhees <bert.verhees-OjSWxgR8lhI@xxxxxxxxxxxxxxxx> 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: > >sqlite-users-unsubscribe-CzDROfG0BjIdnm+yROfE0A@xxxxxxxxxxxxxxxx > >For additional commands, e-mail: > >sqlite-users-help-CzDROfG0BjIdnm+yROfE0A@xxxxxxxxxxxxxxxx > > > > > > > > > > > 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: sqlite-users-unsubscribe-CzDROfG0BjIdnm+yROfE0A@xxxxxxxxxxxxxxxx For additional commands, e-mail: sqlite-users-help-CzDROfG0BjIdnm+yROfE0A@xxxxxxxxxxxxxxxx