I accept that fulltext index would be bloated due to all the atomic
indexing it has to do.
BUT, looking at my mysql db directory, for each table, there is a
single index file consisting of all the indecis - regular and fulltext
put together.
The result is that to access any simple index, the whole monsterous
index file has to be pulled into ram, sucking life out of my server.
Short of creating a different table just to hold the fulltext data,
anything I can do??? The situation is not acceptable.
--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/mySQL-Fullte...ict153690.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=514564