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! John -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
