>Richard was saying he had sped up LIMIT queries in 3.24. I checked this out >and was running LIMIT queries >in sqlite expert (3.23.1) and my app (3.24). >The former was taking 3 times as long to run the queries (not >sure how much >of that was down to improvements or sqlite expert). Anyway, I was getting >quite excited >until I realised I was conducting the test with a warm cache. >When I tried the same with a cold cache I felt >depressed even though the >factor of 3 was still evident.
I’m talking drivel there. Having checked I must’ve been doing the sqlite expert queries on a cold cache and the ones in my app on a warm cache. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users