On 12/09/2011 04:02 PM, Tal Tabakman wrote:
Hi Guys, I have an SQLITE database of 1.5 million rows in a single table each raw looks like:1499999|25|439198507|-1|0|1|44954|24|17|31|9|9|-1|-1| now, from the sqlite command line interface I am creating an on a sincle integer column CREATE INDEX IND1 ON ENTRIES (snum) the result I get is: Error: disk I/O error can you advice how to debug this one ?
You might be running out of space wherever temporary tables are stored on your system. If you're on unix, try changing environment variable TMPDIR to point to somewhere you have lots of free disk space (say three times the size of the eventual index). Or (I think) environment variable TMP or TEMP on Windows. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
