Disable full-text Index update stops search services
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.
Subject
Views
Written By
Posted
Disable full-text Index update stops search services
5919
March 12, 2006 12:30AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.