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
