Hello, I am trying to troubleshoot a problem that I'm having with a program usingSQLite over a wireless network.? I know that wireless networks can havetheir own sets of issues that cause database access problems. What is happening is that something that takes 1 or 2 seconds on a wirednetwork will take 15-20 seconds over wireless.?
I am using System.Data.SQLite, which is based on version SQLite 3. 8.8.3 (version 1.0.96.0)with C# Visual Studio. The program is installed and runs off a network. The database is also on a network. The reads are somewhat slower running on a wired network than when run on a local machine.However, when run over wireless it is significantly slower.? These are mostly reads onfairly simple queries.? Are there any pragmas that may be used to increase the latency or to allow thereads to process faster across a network??? Or are there any other tips or tricksthat may be used to speed up access? This is a multi-user database with about 2-10 usersreading/writing data. Most of the time, the client application sits idle.? The SQLite connectionsare opened only on demand, then closed after I/O operations. However this opening and closingis kept to a minimum. ThanksMike
