Hi - it only happens on Windows systems that are using U3 USB keys. None of the queries are intensive - they are pretty simple and shouldn't take longer than a few milliseconds.
On harddisks it *always* works. Never had an issue there. On Fri, Apr 3, 2009 at 5:15 AM, Emil Obermayr <n...@nobswolf.info> wrote: > On Thu, Apr 02, 2009 at 08:20:38PM -0700, Dave Brown wrote: > > Our software often runs into problems when run on USB keys. Specifically, > > calls to sqlite to read/write to the database hang infinitely, or return > > Does it work on harddisk? > > I can tell RO-access works nicely on Windows XP. > > Do you have those timeouts only with some request; or does it happen > even with very simple ones like select * from smalltable; ? > > I can tell sqlite takes a very long time with unbracketed joins. The > performance is way better with brackets around each join. > > Do you have more than one process connected to the file at a time? Maybe > they are blocking each other. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
