[rt-users] RT3 speed thread

Michael van Elst mlelstv at dev.de.cw.net
Mon Jun 2 10:40:09 EDT 2003


On Mon, Jun 02, 2003, Simon Woodward wrote:

> Anything from about 1 to 5(+) minutes from clicking a link to having the
> results displayed.

What kind of link ? View a single ticket ? Search tickets ?

> Watching MySQL logging as it goes through, it seems to be just ACL lookup after
> ACL lookup until the page eventually displays.

You could do thousands of ACL lookups per minute. Any rough number on how
many queries before the page displays ?

I found that a simple creation of a single ticket using the mailgate for an
existing user takes _113_ SQL commands (21 * insert, 12 * update, 80 * select).
But that's still only 2 seconds and about 30% of the CPU time.

Greetings,
-- 
    ,eM""=.            a"-.                         Michael van Elst
   dWWMWM" -          :GM==;                        mlelstv at dev.de.cw.net
  :WWMWMw=--.          "W='  cable & wireless
   9WWMm==-.
    "-Wmw-"  CABLE & WIRELESS



More information about the rt-users mailing list