word index - is there a better solution?
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.
Subject
Views
Written By
Posted
word index - is there a better solution?
4747
June 03, 2010 01:36PM
1583
June 04, 2010 07:40PM
1502
June 04, 2010 08:49PM
1573
June 04, 2010 11:33PM
1381
June 05, 2010 12:21AM
1409
June 05, 2010 12:41PM
1581
June 05, 2010 01:45PM
1429
June 05, 2010 09:13PM
1239
June 06, 2010 10:13AM
1438
June 06, 2010 07:36PM
1394
June 06, 2010 08:29PM
1385
June 07, 2010 09:29AM
1332
June 07, 2010 01:02PM
1062
August 27, 2010 08:37PM
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.