On Fri, Jun 3, 2011 at 6:58 AM, Ian Hardingham <i...@omroth.com> wrote:
> > I may be looking at a complete re-write. I may also need to have a > solution which scales beyond one machine. Can anyone give me advice on > this matter specifically? > > See http://www.sqlite.org/whentouse.html for general usage help. May I suggest to measure before optimizing? It is a common mistake to optimize before optimizing in general. By measuring your various queries, you may find a nice index that would help your short term issues, or simply adjusting some parameters. I found in the past that auto-index would make a query a lot slower, just because the SQL ANALYZE was not run. Your problems may be a simple as this. That will leave you with more time if you indeed need to go to a client/server DB setup. I think I'll give Frozen Synapse a try... -- Martin _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
