Martin Engelschalk wrote: > perhaps you could drop the primary key. The query you mentioned, > SELECT count(*) FROM table WHERE column = '%q' > does not utilize it
Does too. Primary key provides the index for the search. Without it, SQLite would do full table scan. Use EXPLAIN QUERY PLAN to convince yourself. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
