On Mon, Jan 16, 2012 at 5:37 PM, John Elrick <john.elr...@fenestra.com>wrote:
> > is this test ok for you (still showing bad performance)? > > > > On my side it's about 800 ms for 3.7.9 static and about 6000 memory calls > > during the query. For 3.6.20 the number of calls ~ 7000, the time is > > similar. > > > > > Your test was hard coded. Mine uses bindings. However, I'm not arguing > that something odd is going on. I'm just trying to understand what. > Ok, I did a test with bindings This was query UPDATE RESPONSES SET RESPONSE_NAME = ?, prelisted_value=? WHERE RESPONSE_OID = ? with 5000 rows where both strings were 'abc' and the numbers - random ids (existing) I noticed similar results when the results are system-cached (second and following test in sqlite even after reopening), but when I force resetting system cache (windows cache, not sqlite), the time is about 7-11 seconds. But I think a test db with test data would be more useful for understanding. Can you upload it? Max _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users