Thanks for your answers! First of all, my apologies with ANALYZE I meant that it increased performance (decreased query time) by orders of magnitude.
Before ANALYZE the query was in the order of seconds (about 2 seconds). After ANALYZE the query was in the order of milliseconds. I tried VACUUM too, but didn't improve query time. I'm now trying saving the result to a temporary table (I set temp_store=memory to avoid writing on disk), it looks like, by saving only the rank, the query takes about 50 ms, which is a very good time.. And then extracting the first 15 records ordered by rank becomes very fast thanks to an index. This is already very useful because it may happen that we query the same term over and over to scroll down the result by rank. Any other tips are always appreciated. Thanks again! Gabriele _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
