Re: [sqlite] Looong sql queries (>9 seconds)

2008-09-18 Thread Jeffrey Becker
Actually I think you can drop the index on just rate. On Thu, Sep 18, 2008 at 3:12 PM, John Stanton <[EMAIL PROTECTED]> wrote: > I would get rid of your separate columns for day, month and year and use > the Sqlite date format and use an index on it. > > chris wrote: >> I'm at a loss and need

Re: [sqlite] Looong sql queries (>9 seconds)

2008-09-18 Thread John Stanton
I would get rid of your separate columns for day, month and year and use the Sqlite date format and use an index on it. chris wrote: > I'm at a loss and need some guidance. My queries are taking way longer than > I can use but I'm not sure what steps to take next. > > I'm using SQLite 3.6.2

Re: [sqlite] Looong sql queries (>9 seconds)

2008-09-18 Thread jason weaver
On Thu, Sep 18, 2008 at 11:58 AM, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > > On Sep 18, 2008, at 12:46 PM, chris wrote: > > I'm at a loss and need some guidance. My queries are taking way longer >> than I can use but I'm not sure what steps to take next. >> >> >> Try this and see if it

Re: [sqlite] Looong sql queries (>9 seconds)

2008-09-18 Thread Jeffrey Becker
Try creating an index on settings(rate) On Thu, Sep 18, 2008 at 12:46 PM, chris <[EMAIL PROTECTED]> wrote: > I'm at a loss and need some guidance. My queries are taking way longer than > I can use but I'm not sure what steps to take next. > > I'm using SQLite 3.6.2 on a small reasonable

[sqlite] Looong sql queries (>9 seconds)

2008-09-18 Thread chris
I'm at a loss and need some guidance. My queries are taking way longer than I can use but I'm not sure what steps to take next. I'm using SQLite 3.6.2 on a small reasonable powerful embedded platform with 256M ram. I'm using Python to access the database. I've created a very simple database