I've created a test database with almost one million records (about 20 fields each). I noticed, that the simple query like "select count(*) from table" takes about 10 seconds (the database file is of about 300 MB size).
I'm wondering: is it the limit - or is it still possible to reduce the response time? I mean the simplest queries here, mostly: "select * from", "...where something=''", "...where something like '%that%'. Yes, I know: indexing. Unfortunately, indexing won't have any effect on "count(*)". But of course, indexing tips are welcome too (for SELECT ...). Found a page http://web.utk.edu/~jplyon/sqlite/SQLite_optimization_FAQ.html - but perhaps someone gathered some more tips? Maybe latest versions of SQLite (the page is from 2003) are giving some more options for tuning? -- pozdrawiam / regards Zbigniew Baniewski _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
