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?
4987
June 03, 2010 01:36PM
1675
June 04, 2010 07:40PM
1595
June 04, 2010 08:49PM
1676
June 04, 2010 11:33PM
1482
June 05, 2010 12:21AM
1503
June 05, 2010 12:41PM
1673
June 05, 2010 01:45PM
1525
June 05, 2010 09:13PM
1342
June 06, 2010 10:13AM
1541
June 06, 2010 07:36PM
1500
June 06, 2010 08:29PM
1504
June 07, 2010 09:29AM
1445
June 07, 2010 01:02PM
1151
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.