Hi, One more information: I am using COLLATE NoCase.
On Thu, Dec 10, 2009 at 4:19 PM, Harish Dixit <harishdix...@gmail.com>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