It isn't clear what you are trying to determine. What provider are you using for ADO.NET (eg Jet, SQL Server, etc)?
Are your inserts for SQLite inside a transaction? This makes a huge difference. If you are using ADO.NET, you might look at http://sourceforge.net/projects/adodotnetsqlite > -----Original Message----- > From: Arthur Hsu [mailto:[EMAIL PROTECTED] > Sent: Friday, November 14, 2003 6:29 PM > To: Andrew Shakinovsky; [EMAIL PROTECTED] > Subject: Re: [sqlite] Performance tuning question > > > Hello, > > I managed to download new CVS versions (by hand ...) and > compile them on Win32 platform (finally). Following are my > test results: > > Time elapsed ADO.Net SQLite 2.8.6 SQLite CVS > 0 0 0 0 > 30 7419 5729 7920 > 60 14176 8013 10711 > 90 20760 9869 13147 > 120 26623 11033 14944 > 150 32862 12633 16598 > 180 38783 13044 17878 > 210 44472 13098 19609 > 240 49873 14120 20711 > > The CVS version is quite linear after the first 30 seconds. > I'm still digging the reason for the performance difference > between 0-30 and 30-60. Any ideas? > > -Arthur > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
