Kevin O'Gorman wrote: > CREATE INDEX has two problems: > 1) poor default location of temporary storage. > 2) gets wedged on very large indexes. > > I'm using the sqlite that came with Xubuntu 14.04, I think it's version > 3.8.2.
SQLite-3.8.2 is old (Dec 2013). It's better to download and compile SQLite yourself. There has been several optimizations since that release. In particular, looking at release notes at https://sqlite.org/changes.html the following improvement which may be relevant for your issue: === BEGIN QUOTE https://sqlite.org/changes.html === 3.8.10: Performance improvements for ORDER BY, VACUUM, CREATE INDEX, PRAGMA integrity_check, and PRAGMA quick_check. === END QUOTE === Regards Dominique _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users