RE: [sqlite] Performance tuning question

2003-11-15 Thread Arthur C. Hsu
Okay maybe you guys didn't follow up my previous mails. I give a brief intro again. I'm using SQLite in my program, and I have 2 threads. One thread performs insert, and the other thread perform update. The number below is the table showing that how many rows are inserted in given time. I

RE: [sqlite] Performance tuning question

2003-11-15 Thread Tim McDaniel
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 >

[sqlite] Indexes

2003-11-15 Thread Brian Pugh
Hi, My current database is mainly names and addresses. Most of my record viewing is done by: "select * from TableName order by Zip,Address,No" Zip, Address and No (house number) have separate indexes. On other databases I have used, I have combined these three columns into one index, and used

Re: [sqlite] Performance tuning question

2003-11-15 Thread Bert Verhees
On 14 Nov 2003 at 16:28, Arthur Hsu wrote: > Hello, > > I managed to download new CVS versions (by hand ...) and compile them on > Win32 platform (finally). Following are my test results: > > Time elapsedADO.NetSQLite 2.8.6SQLite CVS > 0 0