Re: like and match in blobs

From: "Martin A. Marques" <martin@math.unl.edu.ar> > >On Mon, 07 Aug 2000, Obnoxio The Clown wrote: > > From: "Martin A. Marques" <martin@math.unl.edu.ar> > > > > > >I would like to have some thoughts on how informix ODS 7.30 would work >on > > >Solaris for Intel making searchs of text strings inside blobs (text). > > >I would like to know how the performance is, because I was told that >the > > >DataBase servers (almost any) don't work well when looking for >substrings > > >in > > >large pieces of text. > > > > IDS.2000, Verity text search datablade. Whizzo! > >Well, we need an upgrade right away, becuase informix ODS 7.30 (the one we >have) doesn't work with Solaris 8, and we are moving to Solaris 8. >I have seen that the problem was fixed in several versions of Informix (It >was a problem with solaris using ipv6 as default instead of ipv4) but don't >know if Informix2000 will work OK on Solaris 8. I think it does. >Another thing is.... is IDS.2000 necesary to use the modules like verity or >Excalibur? It looks like it is necesary, but wanted to check it out. Yes it is. Also, you can't use MATCHES with TEXT types. Which is even worse than a performance problem... ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com