On Fri, Nov 20, 2009 at 11:41:50AM +0000, Dominic Hargreaves wrote: > I'm migrating from an RT 2 install to an RT 3.8 install with around > 170 privileged users (and around 90,000 total users). > > I've done some initial testing with RT 3.8.6 and have observed > that building the list of privileged users (in the "create new > ticket" (ticket owner), "display ticket" (reminder owner) and > "ticket search" (ticket owner) pages) takes around 20-30 seconds to run. > > It performs two queries which are logged by my slow query logger:
Sorry, I wrote this a few days ago, and forgot to note that I have worked around this: http://github.com/jmdh/rt/commit/83b2c9fe39be7ec9ce32940f82b0d47c1025b482 but I haven't fully analysed the impact of this, only that it doesn't make any difference with our data - it's clearly not suitable for general use. -- Dominic Hargreaves, Systems Development and Support Team Computing Services, University of Oxford
signature.asc
Description: Digital signature
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com