Simon Slavin wrote: > > I'm hoping that Joe Mistachkin, or someone else who understands > that library sees this, just to check that it works the way > you're expecting it to. >
Judging from the description so far, I think that both SQLite and System.Data.SQLite are working correctly. It is true that System.Data.SQLite has an internal retry mechanism that will wait 150ms between retries. The PrepareRetries property for the SQLiteConnection object is the maximum number of retries. By default, it is 3, which means the total wait should be around 450ms by default. That being said, I have not personally seen any built-in Windows application or system service prevent SQLite from access a file for more than a fraction of a second. Maybe things are different if the Windows AV subsystem actually finds something "bad" in the file? -- Joe Mistachkin _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
