On 19 Apr 2011, at 2:58pm, Adam DeVita wrote: > Our application is typically implemented on a standard laptop PC. It seems > that the symptoms displayed are consistent with what this list describes > would happen, so it looks like I can start thinking of how to write a > defence. It does suddenly become very slow. > > I think the potential solutions we may implement are all in application > code, so not really an SQLite problem.
If you are using an in-memory database purely for speed, you might try the simple change of not doing that. Make your database use disk space as any normal one would, and delete it after you close it. Windows is pretty good at caching stuff these days and on-disk databases aren't as slow as some people would guess. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
