[rt-users] "Final priority" and full-text transaction search

Jesse jesse at fsck.com
Thu Apr 20 16:11:41 EDT 2000

On Thu, Apr 20, 2000 at 04:08:20PM -0400, Rich Graves wrote:
> On Thu, 20 Apr 2000, Jesse wrote:
> > no. there is no way to do a search from within RT. This is fixed in
> > 2.0. The technical reason we store transaction content in textfiles
> > dates back to the earliest days of RT ... when it used mini-sql..which
> > had no blob support. RT 2 is designed against modern databases which
> > allow such things :)
> You still can't index BLOBs in most databases, so if you have a lot of
> tickets it will be slow and inefficient. I'll probably stick with the
> htdig wrapper hack for a while.
*nod* The thought was to move "old" tickets to a data warehouse rt instance.
also, you'll be able to cut down search time by limiting the search in other 

> Oracle 8i Intermedia is getting there... I noticed a month or two ago that
> www.oracle.com had finally switched from an AltaVista search engine to
> their own product. It won't work reliably on Linux though.
> -- 
> Rich Graves <rcgraves at brandeis.edu>
> UNet Systems Administrator
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users

jesse reed vincent -- jrvincent at wesleyan.edu -- jesse at fsck.com 
pgp keyprint:  50 41 9C 03 D0 BC BC C8 2C B9 77 26 6F E1 EB 91
Any e-mail sent to the SLA will immediately become the intellectual property
of the SLA and the author of said message will enter into a period of
indentured servitude which will last for a period of time no less than seven

More information about the rt-users mailing list