Re: Slow Fulltext Index Creation

2003-02-11 Thread Sergei Golubchik
Hi! On Feb 12, Peter Bryant wrote: > Hi. I'm adding a fulltext index to two fields in a large (2300MB) table. > > The index created the first 200MB or so of data pretty quickly (in a couple > of hours), but progress from there has been very slow. > > After 48 hours the temporary table is only

Slow Fulltext Index Creation

2003-02-11 Thread Peter Bryant
Hi. I'm adding a fulltext index to two fields in a large (2300MB) table. The index created the first 200MB or so of data pretty quickly (in a couple of hours), but progress from there has been very slow. After 48 hours the temporary table is only 640MB / 2300MB original table size. I've chang