"Marian Aldenhoevel" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > SELECT COUNT(*) FROM sometable; > > Takes 10 seconds on my testcase (340.000 rows, Database on CF, dead > slow CPU). > > Is there a quicker way? Does SQLLite maybe store the total number of > records somewhere else? > > The table only ever grows, there are now DELETEs on it ever, apart > from complete truncations now and then.
In this case, see if this statement gives you an accurate count: select max(rowid) from sometable; Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
