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
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
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
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
4 matches
Mail list logo