> -----Original Message----- > From: Frank Baumgart [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 02, 2004 11:08 AM > To: [EMAIL PROTECTED] > Subject: Re: [sqlite] Faster way to perform this query? > > > > Currently on Sqlite version 2.8.13, this query on tables > with 1000 rows > > each, returns 50 rows but it takes about 30 seconds. Is > there anyway to > > significantly speed up this query? > > Do you have indices on "startTime" and "endTime"? > > Frank >
Hi Frank Thank you very much for the reply. No, I don't have indices on these columns. I take it I should. :) Thanks again and take care. RZ
