On Thu, Jun 6, 2013 at 11:26 AM, Gabriel Corneanu <gabrielcorne...@gmail.com > wrote:
> > 2. Is there NO WAY to quickly get the row count WITHOUT full scan if I > only have the auto primary key?? > The b-tree structures in the SQLite file format do not store the row count, as that slows down writes (since the row count would have to be updated with each insert or delete). If you want fast access to a row count, store it in a separate table and keep it up-to-date using triggers. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users