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
