> -----Original Message----- > From: Neelamegam Appadurai [mailto:[EMAIL PROTECTED] > Sent: 25 February 2005 05:04 > To: sqlite-users@sqlite.org; [EMAIL PROTECTED] > Subject: Re: [sqlite] Re: sqlite performance variationin > linux and windows > > Hi, > Thanks for the quick response and the interest you're > showing, I am testing the performance of linux and windows > using a. same testing data for both. > b. db schema is common for both. > c. though the test is conducted on two different machines but > the machine configurations are similar.
I would say you need to do some profiling to find out which calls are taking longer. Which version of Windows is this? At one time I discovered an extraordinary slowdown with Sqlite on Windows 98 (but not 2000 or XP). Keeping a transaction open fixed the problem in that case. Tim
