MySQL Forums
Forum List  »  Performance

word index - is there a better solution?
Posted by: Craig Logan
Date: June 03, 2010 01:36PM

hi there,

I'm currently working on a system that allows users to search in about 500M documents (+5M every month).

now the standard approach would of course be to create a word index. this would, however, result in a table of about 100B rows, which kinda scares me because of the performance and maintenance implications (for example, file size limits and how we're going to backup this beast).

I have had mySQL tables with several billion rows that worked fine performance wise, but I guess 100B rows could be a different story.

so basically, I am wondering if there's a different approach for this (even though I'm pretty sure there isn't).

thanks.
craig.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.