Disable full-text Index update stops search services

[Martin Feng]

MySQL version: 5.0.15.

I need to insert to a table having full-text indexed column several thousands rows per day. To speed up the insert, I run

ALTER TABLE DISABLE KEYS

before insertion to stop full text index update during insertion. After insertion, run

ALTER TABLE ENABLE KEYS

to rebuild the full text index.

There is only insert operation; no delete or update run on this table.

The problem is during the insertion, the full text search ability is also disabled.


Question:

Is there a way to stop full text index update during insertion, but still provide full text search ability using original index?



Edited 2 time(s). Last edit at 03/12/2006 12:36AM by Martin Feng.