Re: [sqlite] Index Problem

[Harish Dixit]

Hi,

One more information:
I am using COLLATE NoCase.

On Thu, Dec 10, 2009 at 4:19 PM, Harish Dixit wrote:

> Hi Friends,
>
> I ran into a big problem of creating indexes taking a long time. When i
> create index on multiple colomns then its taking a long time on few
> machines. Those are windows Vista machines. I am using following command:
>
> CREATE INDEX IF NOT EXISTS New_Index (name COLLATE NoCase ,title COLLATE
> NoCase)
>
> I tried with empty database also again its taking long time. Since indexes
> are already created then why its taking long time.
> Its taking time from 500-800 ms. while on other machines its taking less
> time 40-80 ms.
>
>
> Best Regards,
> Harish.
>
>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Index Problem

[Harish Dixit]

Hi Friends,

I ran into a big problem of creating indexes taking a long time. When i
create index on multiple colomns then its taking a long time on few
machines. Those are windows Vista machines. I am using following command:

CREATE INDEX IF NOT EXISTS New_Index (name,title)

I tried with empty database also again its taking long time. Since indexes
are already created then why its taking long time.
Its taking time from 500-800 ms. while on other machines its taking less
time 40-80 ms.


Best Regards,
Harish.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users