which database is best for match querying

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

    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?

    Tags: None
    • 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.

          --
          403 Forbidden
          http://www.mgogala.com


            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

                    Previous template Next
                    Working...