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

[Bert Verhees]

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

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]