I have 300k rows in my db, 1 gig of ram. I do fulltext indexing on a
large field (textual). It appears that fulltext indexing puts a lot of
strain on my server. I start bumping up iowait numbers pretty hard.
Has anyone seen this, anything I can do.
Alternative is to build tables of words as PHPBB does.
Any performance tradeoffs. I do know the functionality tradeoffs.
Thanks,
steve
--
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...ict126150.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=420465