Roger Binns <[email protected]> writes: > Nikolaus Rath wrote: >> 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? > > The UPDATE time also includes the time waiting to acquire file locks. If > you have concurrent activity it could take a while.
The 11x performance difference is for single threaded runs (but it is actually about the same with threading as well). 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
