Re: [sqlite] Index Problem

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 >

[sqlite] Index Problem

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