Ok.. I thought we should try doing the search algorithm in VB first. Here it is:
Set rec = OraDatabase.CreateDynaset ("ENTER SQL HERE TO GET ALL POSTS", 0) do until rec.eof Set txtbody = OraDynaset.Fields("Body").Value 'Read entire CLOB value, buffer must be a Variant AmountRead = txtbody.Read(buffer) 'sets to zero if not found pos=instr(1,lcase(buffer),lcase(SearchString)) if pos<>0 then 'do what you want here with found item end if rec.movenext loop rec.close set rec=nothing
Try this out... if it is too slow, then I will make the same thing in PL/SQL. Let me know Gor as soon as you test it... i am interested in the performance.
Forum Locked
Posted - 02 April 2001 : 15:55:11
