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 more memory, until it reached about 90% memory use, after which cpu usage drops. Also, I don't see the size of the database file increasing, which I guess should happen while the index is created. I increased the cache size to 200000000 but to no avail. Can it be that this table is somehow too large to index? Or should I just wait longer? If so, how, do I know? Any other ideas?
Thanks! _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
