Re: [sqlite] Speed of DROP INDEX This may not be useful to your situation, but my (not terribly informed) *guess* is that the reason it takes so long is that the index pages are spread throughout your 8-millon row database.
If by chance it's feasible to either: -- Not create the index until the table is populated, or -- Run vacuum at some "non busy" time between the table creation and the need for index deletion Then perhaps the delete would be quicker. A side benefit might be faster lookups. Again, even if I'm corrent, this may not be feasible for your application. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users