On Fri, Apr 04, 2008 at 11:19:53AM -0400, Samuel Neff wrote: > Is it really a full table scan or just an index scan (at least in the case > where no data is needed from the table as in the original sample that had no > join or where clause).
Either way it's O(N) instead of O(1), which is what the original poster expected. Not fetching the column data will hardly help the poster. I think the trigger workaround is just fine. It might be nice if SQLite just optimized this anyways (e.g., keeping the row count in sqlite_master or some other sqlite_* table), mostly to avoid the FAQ, and to help porting to SQLite. Nico -- _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
