Re: search engine for text blobs

Alan Goodman wrote > >I was wondering how you people have implemented search engines on text >blobs. > >For example, I am going to keep track of trouble calls from the software >support department. I will save the notes from each support call into a >text blob that is part of the support call record. > >I really don't want to select each blob out of the database and then >"grep" it. That might be a little slow. 8-) > >So, anyone have a better way? Don't know if this is a better way. What about using WAIS? Write the blob through a SP, get a uniqe field (or a serial), write a text file containing your blob. Those text file must be indexed by WAIS, then delete it. If you start a search against this WAIS database, the (temporary) file name will be returned and you can easily find the blob using the return value as unique field. -- Chris Drauch ...................................................................... . c/o DRAUCH Ges.m.b.H. Tel. 43/ 3135/46387-0 . . Gewerbestrasse 5 Fax 43/ 3135/4638728 . . A-8071 Hausmannstaetten EMail cdr@xteam.co.at . ......................................................................