text search question
This is a discussion on text search question within the PHP Language forums, part of the PHP Programming Forums category; I'm working on a new project with php & mysql. I anticipate that one of the tables may grow ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-17-2005
|
|||
|
|||
text search question
I'm working on a new project with php & mysql.
I anticipate that one of the tables may grow above 40 GB in a short time. The main content is text. Now what tools do I need to implement a text search in this big text database ? I'd like the search to be quite advanced, supporting boolean operations and metaphones and so on. What should I be surveying now ? Any hints/pointers/suggestions/comments/ advise on concepts ? Thanks Mike 
|
|
04-18-2005
|
|||
|
|||
|
Re: text search question
On Sun, 17 Apr 2005 13:51:25 -0700, siliconmike wrote:
> I'm working on a new project with php & mysql. > > I anticipate that one of the tables may grow above 40 GB in a short > time. The main content is text. Now what tools do I need to implement a > text search in this big text database ? I'd like the search to be quite > advanced, supporting boolean operations and metaphones and so on. > > What should I be surveying now ? > > Any hints/pointers/suggestions/comments/ advise on concepts ? You will need a commercial text search and indexing tool. Oracle*Text is one such tool. I was consulting for a company that was using it and they were very happy with the tool. This group might not be the right place to ask such a question. Of course, PHP supports Oracle so you will be able to interface PHP with Oracle*Text. -- Egoist: A person of low taste, more interested in themselves than in me.
|
|
04-18-2005
|
|||
|
|||
|
Re: text search question
Mladen Gogala wrote:
> On Sun, 17 Apr 2005 13:51:25 -0700, siliconmike wrote: > >> I'm working on a new project with php & mysql. >> >> I anticipate that one of the tables may grow above 40 GB in a short >> time. The main content is text. Now what tools do I need to implement a >> text search in this big text database ? I'd like the search to be quite >> advanced, supporting boolean operations and metaphones and so on. >> >> What should I be surveying now ? >> >> Any hints/pointers/suggestions/comments/ advise on concepts ? > > You will need a commercial text search and indexing tool. Oracle*Text is > one such tool. I was consulting for a company that was using it and they > were very happy with the tool. > This group might not be the right place to ask such a question. Of course, > PHP supports Oracle so you will be able to interface PHP with Oracle*Text. > or you could try mnogo without selling your internal organs. C.
|
Linear Mode
