... > now, i tried to put the index on the table afterwards. i tried this when > the table was real big > (600Mb, about 40.000.000 rows).. After six hours, sqlite had read and > wrote 150Gb (!) to disk > (that is: reading 150Gb, writing 150Gb according to windows taskman) the > job still wasn't done.. > i had to kill the job.
It seems obvious to me that you are not using transactions. Use BEGIN/COMMIT. Frank Baumgart --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
