[rt-users] Performance with many attachments and transactions

[Ruslan Zakirov]

On 11/28/05, Stephen Turner <sturner at mit.edu> wrote:
> At Monday 11/28/2005 01:13 PM, Jesse Vincent wrote:
>
>
> >Seams reasonable enough. I've created a ticket for this one, but it'll
> >likely get fixed a lot faster if someone steps up with a patch.
> >
> >Jesse
>
> Can you clarify the requirements? It seems like there are all kinds of
> conditions on whether to display an attachment or not that would be
> difficult to cram into a single database query.
>
> What would be relatively simple though (I think), is to add a "size less
> than MaxInlineBody" limit to the query that gets text attachments. Would
> that be enough?
We could build "LENGTH(Content) < $MaxInlineBody" condition, but we
can't use ContentLength property because it's buried in the Headers
field. You should look into SB to see how to do such limit.

>
> Thanks,
> Steve
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com
>
> Download a free sample chapter of RT Essentials from O'Reilly Media at http://rtbook.bestpractical.com
>
> WE'RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
> San Francisco - Find out more at http://bestpractical.com/services/training.html
>


--
Best regards, Ruslan.