Hello,
We use Qt with sqldriver Sqlite-4 in our application. (Windows XP 32 bit,
Visual studio 2005)
We are facing a performance issue in the following scenario.
There are two processes A and B. A uses sqlite DB1 and keeps populating data.
Process B uses sqlite DB2 for writing and occasionally opens DB1 for reading.
What we notice is when A is writing into DB1, B hangs for a couple of seconds
even though it is not performing any DB operations on DB1/DB2.
On opening Windows event viewer, we see that process B is making a lot of
registry calls and is accessing disk a lot during the time that process A is
writing to DB1 and process B really is not doing any DB operation at that time.
For now, we have not been able to identify if this is happenning inside Qt sql
module or inside sqlite.
But would any one know if there is any kind of synchronization that is done
between different processes that connect to different sqlite databases that
might slow down one process when the other process is performing DB operation
on its sqlite DB?
Thanks in advance!
This message and any attachments are solely for the use of intended recipients.
The information contained herein may include trade secrets, protected health or
personal information, privileged or otherwise confidential information.
Unauthorized review, forwarding, printing, copying, distributing, or using such
information is strictly prohibited and may be unlawful. If you are not an
intended recipient, you are hereby notified that you received this email in
error, and that any review, dissemination, distribution or copying of this
email and any attachment is strictly prohibited. If you have received this
email in error, please contact the sender and delete the message and any
attachment from your system. Thank you for your cooperation
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users