Hi, When running apswtrace on my Python program, I got the following output:
LONGEST RUNNING - AGGREGATE 16638 11.041 UPDATE inodes SET size=MAX(size,?), ctime=?, mtime=? WHERE id=? 16638 0.938 SELECT s3key FROM inode_s3key WHERE inode=? AND offset=? i.e. both statements were executed 16638 times, but execution of the first took 11 seconds in total and execution of the second only 0.9 seconds. I was slightly surprised by this. The UPDATE statement just writes one integer and 2 reals. There is an index on the id column, and I have activated PRAGMA temp_store = 2 and PRAGMA synchronous = off. Is it normal that UPDATE still takes more than 11 times as much time as SELECT, or should I be able to get better performance? Best, -Nikolaus -- »Time flies like an arrow, fruit flies like a Banana.« PGP fingerprint: 5B93 61F8 4EA2 E279 ABF6 02CF A9AD B7F8 AE4E 425C _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
