Hello Dave, Friday, April 3, 2009, 12:16:37 PM, you wrote:
DB> Hi - it only happens on Windows systems that are using U3 USB keys. None of DB> the queries are intensive - they are pretty simple and shouldn't take longer DB> than a few milliseconds. DB> On harddisks it *always* works. Never had an issue there. DB> 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 >> DB> _______________________________________________ DB> sqlite-users mailing list DB> sqlite-users@sqlite.org DB> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users Install and run "ProcMon" on the system and you can watch every write and read to the stick. I use it regularly to trouble-shoot weird disk issues. It's available from Microsoft. -- Best regards, Teg mailto:t...@djii.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
