Hi, ----- Original Message ----- From: "Dennis Cote" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Thursday, May 04, 2006 2:27 PM Subject: Re: [sqlite] SQLite :memory: performance difference between v2 and v3?
> All, > > More mysteries. To investigate this low insert performance under WinXP I > wrote a simple test program that loops writing one character to a file > and then flushing the file. The strange thing is that it seems to > alternate between two different run times as shown below. This is for 6 > consecutive runs. If you are using WinXP with Service Pack 2 this can be the problem. I have experienced a lot of issues with the Windows XP Firewall. The funniest (or strangest) thing I have found so far is that the Firewall seems to block certain things even if it is deactivated. The problem gets a lot worse if you use an Anti-Virus software. In my case I use Viruscan and although I unchecked all the options to check TCP/IP connections, emails, etc it still slows my network traffic down. If I disable it everything works perfectly. For example I work with mysql and connections to query data from the server (another PC in local network) takes forever when Viruscan is active. Just some thoughts. Best Regards, COS
