On 2 Sep 2011, at 3:24pm, Simon Slavin wrote: > On 2 Sep 2011, at 10:04am, Filip Navara wrote: > >> The time to create an index on my 266 Mb experimental database is more >> than 9 minutes. The database is available at >> http://www.emclient.com/temp/mail_index.zip and the command I use to >> create the index is >> >> CREATE INDEX "idx_MailAddresses_address" ON "MailAddresses" ("type", >> "address", "parentId"); >> >> I had run the shell under profiler > > Strangely, on my Mac running the shell tool provided with OS X 10.7.1, SQLite > 3.7.5, there seems to be a problem. It's still going after more than 2 hours.
I correct myself: it had finished. It just wasn't showing the next prompt, for some reason. After force-quitting and restarting the shell it showed the index as existing and the index worked. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users