Re: Fulltext insert/update

2004-11-15 Thread Sergei Golubchik
Hi! On Nov 15, John Smith wrote: > I know that having a fulltext index on a table slows inserts and updates > down (or I think I do...might have miss read something) > > I have a large table that uses fulltext which I plan to update nearly > 90% of the rows (400,00+) and add new ones. > > It cur

Fulltext insert/update

2004-11-15 Thread John Smith
I know that having a fulltext index on a table slows inserts and updates down (or I think I do...might have miss read something) I have a large table that uses fulltext which I plan to update nearly 90% of the rows (400,00+) and add new ones. It currently takes around 35 minutes to remove the ind