> Possible fixes: o Maybe (I know we've talked about this before), another solution is to have the FT index in another file which could have its own cache size settings. o Lastly, we could switch to using word tables that would use already optimized caching of table and index data, but would require a joi or multiple selects (only really advantageous if we want the word tables on a different machine [which has another benefit of reindexing not causing the table to be locked]). Then there wouldn't be any MySQL isssue to deal with, but kinda defeats the point of having FT inside MySQL itself. o OR, we could put a table with FT index on another machine as a copy where we only do fulltext searches. Ideally then, we'd like to not have the datafile, but I guess it would be handy for a rebuild if needed. Sincerely, Steven Roussey Network54.com http://network54.com/?pp=e -- --------------------------------------------------------------------- Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
