Re: [sqlite] Speeding up quer

2004-11-16 Thread Dennis Cote
Lloyd Thomas wrote: > There are no indexes in may tables. Please find the following schemas > for my tables. Would it make more sense to convert my datetime > columns to microtime?. What other recommendations would you make for > these tables? CREATE TABLE users ( > user_id INTEGER PRIMARY KEY,

Re: [sqlite] Speeding up quer

2004-11-16 Thread Ulrik Petersen
Hi again, > There are no indexes in may tables. Please find the following schemas for > my > tables. Would it make more sense to convert my datetime columns to > microtime?. What other recommendations would you make for these tables? > CREATE TABLE users ( > user_id INTEGER PRIMARY KEY, >

Re: [sqlite] Speeding up quer

2004-11-16 Thread Ulrik Petersen
Hi there, > I am have a problem with a query which may well have over 200,000 records. > I > have building a website using PHP and PHP is timing out after 30secs due > the > the size of the call_data table (I think). Is there anyway I can improve > the > following query so that it is faster. I

Re: [sqlite] Speeding up quer

2004-11-16 Thread Paolo Vernazza
Lloyd Thomas wrote: I am have a problem with a query which may well have over 200,000 records. I have building a website using PHP and PHP is timing out after 30secs due the the size of the call_data table (I think). Is there anyway I can improve the following query so that it is faster. I

[sqlite] Speeding up quer

2004-11-16 Thread Lloyd Thomas
I am have a problem with a query which may well have over 200,000 records. I have building a website using PHP and PHP is timing out after 30secs due the the size of the call_data table (I think). Is there anyway I can improve the following query so that it is faster. I think I am using sqlite