--- Jens Miltner <[EMAIL PROTECTED]> wrote: > Am 26.07.2006 um 04:16 schrieb Joe Wilson: > > In order to isolate some variables, what results do you get > > with the default ./configure && make on both platforms? > > (default is temp store = file, non-threadsafe). > > We explicitely define the TEMP_STORE macro in the build settings > (Xcode on Mac, Visual Studio .NET / VC 7 on Windows), so this > shouldn't be an issue.
"Shouldn't be an issue" I've lost count of the number of times I've said this over the years only to find it to be the source of the problem. > > Are you running Windows anti-virus software? > > That might actually be the culprit - I was under the impression that > we tested without, but when I just reconfirmed with my Windows > fellows, they admitted they do have antivirus software installed |-: > Guess I'll have to make sure we run the test again without antivirus > software installed. > > OTOH, our customers might also have antivirus software installed, so > this still would not be a solution :( > Does anybody have advice on how to make sqlite work smoothly with > antivirus software [on Windows]? (Probably depends on the antivirus > software?) Just make note of the performance of each antivirus vendor's software and make recommendations to your customers. i.e., "Works best with XYZ." Barring that, I assume all major antivirus packages must provide a way to skip scanning files created/modified by a certain program, matching a certain pattern, in a certain directory, or having a certain file type. Also, consider running that Task Manager and enable all the column statistics (I/O, threads, VM Faults, Page Faults, etc) to see what's going on while you're running your software. You never know what crazy process might be screwing up your performance. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com