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