Hi, well, i put most things in transactions, but in this case that wouldn't make a difference.
the query was simply: create index idx_linktable on linktable (wid) that ran for hours and hours on the huge table until i killed it, or with benchmarks as described in previous post on the tables with less rows. Op maandag, mei 24. 2004 15:48:18 schreef [EMAIL PROTECTED] : > ... > > 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
