Re: [sqlite] Check for empty table

[Martin Jenkins]

Scott Hess wrote:
What's wrong with "SELECT COUNT(*) FROM table;"?
It scans the whole table. This is OK if the table is small (nearly) 
empty, but if it has a couple of million rowZzzz....

Martin

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------