[Rt-devel] Searches on attachments.content using Oracle
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