On Wed, Feb 28, 2007 at 04:43:49PM -0500, Dmitri Tikhonov wrote:
> Jesse Vincent wrote:
> >What would you like to do/see done as part of a RT summer of code
> >project?
>
> Hi Jesse,
>
> How about improving performance for very large databases (I am talking
> millions of tickets)? There are a couple of approaches I have been
> considering:
I sort of suspect that this one will be relatively hard to pass off as a
student project for the summer (though I've been surprised before ;)
I've recently spent some time with an RT instance running on an entirely
unoptimized MySQL 4.1 with about a million and a half tickets.
Performance was surprisingly eppy (most page loads were well under a
second). What kinds of performance are you seeing? And how many
millions?
Best,
Jesse
> 1. Do away with dynamic policy and calculate it once per user session
> (this would probably require removing per-ticket rights).
>
> 2. Do a better job of caching policy results (*HasRight business) and
> associate it with user session, so they virtually become free. I have
> been given it some thought (and code) lately and can elaborate if you're
> interested.
>
> - Dmitri.
>
--
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
