On 10 Sep 2015, at 7:24pm, Mike McWhinney <eljainc at sbcglobal.net> 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 ORDER BY clauses ? If not, SQLite has to read through your whole table every time you execute a command. If you need help, post your CREATE INDEX commands and your SELECT commands. Simon.