hello, why, on a big table (+5 000 000 rows with RTREE ndex) at the beginning, the select is very slow to return (2-5 secondes), but after 1000 selects, it's start to return immediatly (10 ms) ??
thanks by advance stéphane _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users