By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,627 Members | 1,916 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,627 IT Pros & Developers. It's quick & easy.

text search question

P: n/a
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

Jul 17 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.

Jul 17 '05 #2

P: n/a
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.
Jul 17 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.