On Wed, Jun 18, 2008 at 11:51 AM, Scott Baker <[EMAIL PROTECTED]> wrote: > Stefan Arentz wrote: >> Is it possible to get the size of a table without running a count(*) >> query on it? Even an approximated size would be good for me. >> PostgreSQL has this value in a system table. Does SQLite have >> something similar? > > What wrong with running SELECT count(*) it should be very fast.
It seems to run a full table scan. I have 10+ million rows. S. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users