Re: Text Search Taking Too Long

Posted in 2000

Obnoxio The Clown — Fri, 08 Dec 2000 21:26:31 -0000 — source: Informix-list mailing list archive (1991-1998)

From: "Dave Mascorro" <dave.mascorro@usaa.com> > >I am currently on IDS 7.3. I have a table with approximately 600,000 >records that contains several free text fields (~char(60)) that I have to >search off of. I have to search using a filter such as matches >"*searchstring*". My searches are taking alot longer that my users can >tolerate and was wondering if I can get some performance tips from someone. >I have created indexes on these fields which only help if searching with a >wildcard after my search string (matches "searchstring*"). > >I have not fragmented my table which might help. Any other ideas? 1. Don't use *string*? 2. Upgrade to 9.2x and use a text datablade? _____________________________________________________________________________________ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com