[Rt-devel] Searches on attachments.content using Oracle

Alan Barrett apb at cequrux.com
Mon Aug 23 08:05:34 EDT 2004

On Sun, 22 Aug 2004, Joop van de Wege wrote:
> To put things into perspective:
> select * from attachments where contains(content, 'sendmail')>0 
> 12 rows in ~150msec, that is cached by the database, first time ~25sec.
> select * from attachments where content like '%sendmail%'
> 12 rows in 2:23 first time, ~40 sec every next invocation.

That's impressive.  Does anybody have a similar optimisation for

--apb (Alan Barrett)

More information about the Rt-devel mailing list