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 currently takes around 35 minutes to remove the index and then
> another 35 minutes to re index it.
>
> I don't need to use the index until after I have finised with the
> updateing and run myisamchk -rq --sort-index --analyze --sort-records=7
> on the .MYI file.
>
> Is it worth over an hour of adding and removing the fulltext?
>
> Its just that my code takes 4 hours to finish and I am reluctant to add
> on another hour!
No need to remove the index.
Use
ALTER TABLE ... DISABLE KEYS
(and ... ENABLE when you're done with update)
Yes, it is worth to wait 35 minutes when the index will be rebuilt.
Maintaining live fulltext index is much slower.
(at least, inserting lots of rows into a table with fulltext index could
be up to 100 times slower than adding an index afterwards).
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
