Re: like and match in blobs

Posted in 2000

Topics: Performance & Tuning, Installation, Setup & Upgrades, Platform-Specific Issues

Martin A. Marques — Mon, 7 Aug 2000 12:00:09 -0300 — source: Informix-list mailing list archive (1991-1998)

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. 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. Thanks -- "And I'm happy, because you make me feel good, about me." - Melvin Udall ----------------------------------------------------------------- Mart'n Marqu's email: martin@math.unl.edu.ar Santa Fe - Argentina http://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -----------------------------------------------------------------

↪ replying to Martin A. Marques

Art S. Kagel — Mon, 07 Aug 2000 16:32:04 -0400 — source: Informix-list mailing list archive (1991-1998)

"Martin A. Marques" wrote: > > 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 I believe Sun has a patch to fix that. Art S. Kagel > know if Informix2000 will work OK on Solaris 8. > 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. > > Thanks > > -- > "And I'm happy, because you make me feel good, about me." - Melvin Udall > ----------------------------------------------------------------- > Martín Marqués email: martin@math.unl.edu.ar > Santa Fe - Argentina http://math.unl.edu.ar/~martin/ > Administrador de sistemas en math.unl.edu.ar > -----------------------------------------------------------------