RE: [sqlite] moving from mySQL to SQLite - A guidance request

2004-03-20 Thread Fred Williams
> -Original Message- > From: Darren Duncan [mailto:[EMAIL PROTECTED] > Sent: Friday, March 19, 2004 2:29 PM > To: SQLite > Subject: RE: [sqlite] moving from mySQL to SQLite - A guidance request > > > At 9:47 AM -0600 3/19/04, Fred Williams wrote: > >You have raised some vaild concerns for

Re: [sqlite] Performance problem

2004-03-20 Thread D. Richard Hipp
Shi Elektronische Medien GmbH, Peter Spiske wrote: the following simple query is very slow: SELECT title FROM t1 WHERE ipnode='VZ' ORDER BY author; The database is about 250 MB in size and the table the query is run against has 12 cols and 120,000 rows. Every col has an index. The above query ret

Re: [sqlite] Performance problem

2004-03-20 Thread Darren Duncan
At 1:33 PM +0100 3/20/04, Shi Elektronische Medien GmbH, Peter Spiske wrote: the following simple query is very slow: SELECT title FROM t1 WHERE ipnode='VZ' ORDER BY author; The database is about 250 MB in size and the table the query is run against has 12 cols and 120,000 rows. Every col has an

[sqlite] Performance problem

2004-03-20 Thread Shi Elektronische Medien GmbH, Peter Spiske
Hi, the following simple query is very slow: SELECT title FROM t1 WHERE ipnode='VZ' ORDER BY author; The database is about 250 MB in size and the table the query is run against has 12 cols and 120,000 rows. Every col has an index. The above query returns about 80% of the records. As soon as the