> Don't put the PRIMARY KEY as the first column of your index. Ever. This > applies to all SQL database engines, not just SQLite. > > For that matter, don't put the PRIMARY KEY anywhere in your index. The > PRIMARY KEY will be added automatically at the end, where it belongs. > > If you remove the "id," from all of your indices, I think your performance > will probably improve dramatically.
Richard, Simon, So much for testing at the console over a remote session, while I was used to waiting for a single row, the new query increased by so much it overwhelmed my display, heh. Nice and thanks for that tip! jlc _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users