Hi, Here is the output : 0|0|0|SEARCH TABLE map USING COVERING INDEX map_index (n>?) (~4166 rows) 0|0|0|EXECUTE LIST SUBQUERY 1
I am not sure how can I optimize this ? (Also I checked again and there are 4166 rows in this last result and not 1568 as per my last email.) It seems to be using the the covering index which I guess is the fastest way as Sqlite doesnt need to check the actual table. So why would it slow down and use so much CPU in my last query ? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users