Thank you Igor, I'll do some more thorough profiling. When I run the query:
UPDATE multiturnTable SET complete=1 WHERE id=-50000 This takes ~45ms (as reported by SQLite's profile) - is this in the right ballpark? I'm running a fairly fast modern intel chip here. Thanks, Ian _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users