[sqlite] Improving SQLite performance over a network

2015-09-10 Thread Eduardo Morras
On Thu, 10 Sep 2015 18:24:32 + (UTC) Mike McWhinney wrote: > Hello, > I am using SQLite in a Windows environment. The file storing the > database is on a Windows 2008 server.All other file access to this > server is reasonably fast. However, when doing simple SELECTS and > INSERTS/UPDATESit i

[sqlite] Improving SQLite performance over a network

2015-09-10 Thread Simon Slavin
On 10 Sep 2015, at 7:24pm, Mike McWhinney wrote: > All other file access to this server is reasonably fast. However, when doing > simple SELECTS and INSERTS/UPDATESit is noticeably slower on a network. I am > talking about 50 records. Have you created indexes appropriate to your WHERE and ORD

[sqlite] Improving SQLite performance over a network

2015-09-10 Thread Mike McWhinney
Hello, I am using SQLite in a Windows environment. The file storing the database is on a Windows 2008 server.All other file access to this server is reasonably fast. However, when doing simple SELECTS and INSERTS/UPDATESit is noticeably slower on a network. I am talking about 50 records. Now I h