Re: [sqlite] Faster way to perform this query?

[Frank Baumgart]

> 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