Re: [sqlite] sqlite seems to hang while indexing

> I was trying to create an index on an integer column in a very large > table with over 400,000,000 rows on an Ubuntu ... I > increased the cache size to 2 but to no avail. That's only 200M of cache and your table is much larger. Sqlite can't index/sort efficiently lare data on disc - you

[sqlite] sqlite seems to hang while indexing

Hi list, I was trying to create an index on an integer column in a very large table with over 400,000,000 rows on an Ubuntu server, 8-core opteron 2384, 32 Gb RAM. After a couple of days, the process was still running and nothing seemed to happen. At first, sqlite uses a lot of cpu and more and mo