which database is best for match querying

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • monomaniac21

    which database is best for match querying

    hi all

    im wondering is there a better db than mysql for perfoming queries to
    search textfields for the occurence of a string value? for example does
    oracle have greater functionality is this regard?

  • Andy Hassall

    #2
    Re: which database is best for match querying

    On 8 Jul 2006 15:27:47 -0700, "monomaniac 21" <mcyi2mr3@googl email.comwrote:
    >im wondering is there a better db than mysql for perfoming queries to
    >search textfields for the occurence of a string value? for example does
    >oracle have greater functionality is this regard?
    This would be better asked on a database newsgroup, it's offtopic here.

    Yes, Oracle does have more powerful fulltext searching - look up Oracle Text.
    Of course, you pay a little more for Oracle.

    --
    Andy Hassall :: andy@andyh.co.u k :: http://www.andyh.co.uk
    http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

    Comment

    • Mladen Gogala

      #3
      Re: which database is best for match querying

      On Sat, 08 Jul 2006 23:32:57 +0100, Andy Hassall wrote:
      Yes, Oracle does have more powerful fulltext searching - look up Oracle Text.
      Of course, you pay a little more for Oracle.
      Not necessarily. OracleXE is free as in free beer. It depends no the size
      of your database. In this case size does matter.

      --


      Comment

      • Andy Hassall

        #4
        Re: which database is best for match querying

        On Sat, 08 Jul 2006 23:11:22 GMT, Mladen Gogala <gogala@sbcglob al.netwrote:
        >On Sat, 08 Jul 2006 23:32:57 +0100, Andy Hassall wrote:
        >
        >Yes, Oracle does have more powerful fulltext searching - look up Oracle Text.
        >Of course, you pay a little more for Oracle.
        >
        >Not necessarily. OracleXE is free as in free beer. It depends no the size
        >of your database. In this case size does matter.
        The OP didn't specify the amount of data, but yes I'd forgotten about XE.

        --
        Andy Hassall :: andy@andyh.co.u k :: http://www.andyh.co.uk
        http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

        Comment

        • Chung Leong

          #5
          Re: which database is best for match querying


          monomaniac21 wrote:
          hi all
          >
          im wondering is there a better db than mysql for perfoming queries to
          search textfields for the occurence of a string value? for example does
          oracle have greater functionality is this regard?
          MS SQLServer is quite good. It does full text indexing.

          Comment

          Working...