text search question

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • siliconmike
    #1

    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

    Tags: None
    • Mladen Gogala
      #2
      Re: text search question

      On Sun, 17 Apr 2005 13:51:25 -0700, siliconmike wrote:
      [color=blue]
      > 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 ?[/color]

      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.

        Comment

        • Colin McKinnon
          #3
          Re: text search question

          Mladen Gogala wrote:
          [color=blue]
          > On Sun, 17 Apr 2005 13:51:25 -0700, siliconmike wrote:
          >[color=green]
          >> 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 ?[/color]
          >
          > 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.
          >[/color]


          or you could try mnogo without selling your internal organs.

          C.

            Comment

            Previous template Next
            Working...