Hello,
I found that verifying whether SQLite database is locked takes a
relatively long time. I have an application with 4 threads with separate
database connections. If all threads perform queries that require
exclusive access to the database and runs parallel, processing all
queries in all threads takes 34s. If I put queries requiring exclusive
access to the database in critical section by mutex, it shorten the
execution time to 13s. I would like to ask if there was a way to speed
up check whether the database is locked, so I did not analyze whether
the query requires exclusive access and accordingly to it place query in
a critical section.
I have SQLite database on EXT4 partition in Linux. Memory is HDD.
Thank you very much
Lesek Franek ModemTec s.r.o.
---
Tato zpráva byla zkontrolována na viry programem Avast Antivirus.
http://www.avast.com
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
