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. >> >> <snip> >> Try this and see if it helps: >> CREATE INDEX idx1 ON settings(rate, year, month); >> > Wow! Thanks, Jeffrey and Richard! Just adding the index dropped the query time down into the 3 second range. These two versions had a similiar effects: CREATE INDEX idx1 ON settings(rate, year, month); CREATE INDEX idx1 ON settings(rate); I'll experiment with this whole new world of INDEX and maybe I can get it down even further. Thank you! _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users