I use a full-text index in a MySQL table, and each insert into this table takes about 3 seconds. It seems that MySQL rebuilds (a part) of the full text index after each insert/update. Is this right?
How can I get better performance from the
INSERT? Is there perhaps an option to set when MySQL rebuilds the full-text index?