On Fri, Sep 2, 2011 at 5:23 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > 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.
With SQLite 3.7.7 and older the index creation takes eons since the file is in WAL mode and the journal file grows uncontrollably. Since I run it on small SSD I was never able to let it finish, it always filled up the disk first. Best regards, Filip Navara _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users