Slow Load time for Query Builder

Hi - I’m not sure if this can be answered but whenever I click on
"Tickets" and it loads the query builder it takes a while to load - Much
longer than any other options in the system…

I’m running on a HP Proliant DL365 with Fedora 7 64bit and 72gig
ultra320 15krpm mirrored Raid1+0 drives. So the hardware performance
shouldn’t be the bottleneck I would assume.

Are there any enhancements I can make to RT to make the loadtime of the
query builder faster?

Thanks!

-Adam

Hi – I’m not sure if this can be answered but whenever I click on
“Tickets” and it loads the query builder it takes a while to load –
Much longer than any other options in the system…

I’m running on a HP Proliant DL365 with Fedora 7 64bit and 72gig
ultra320 15krpm mirrored Raid1+0 drives. So the hardware performance
shouldn’t be the bottleneck I would assume.

Are there any enhancements I can make to RT to make the loadtime of
the query builder faster?

Adam -
What rights have you given to RT’s large system groups? (“Everyone”
and “Privileged” are the beasts of which I speak.)

This comes up fairly often on the list, and the usual cause is that

the RT group “Everyone” has the “OwnTicket” right. Because the Query
Builder includes a drop-down select for “Owner”, RT may be building (and
your browser is rendering) a potentially enormous piece of HTML to
populate that dropdown.

If you've given "Everyone" or even just the "Privileged" group

global rights to own tickets, try removing that right and assigning it
only to the group of people within your organization who will actually
be working on tickets.

Cheers,
	Ole

/Ole Craig
Security Engineer
Team lead, customer support

ocraig@stillsecure.com
303-381-3802 main support line
303-381-3824 my voicemail
303-381-3880 fax

www.stillsecure.com

Hi Ole - here is my configuration

Everyone Current rights
CommentOnTicket
CreateTicket
ReplyToTicket

Privileged Current rights
No rights granted.

Unprivileged Current rights
No rights granted.

And then the individual groups are assigned rights etc etc.

Thanks

-Adam-----Original Message-----
From: Ole Craig [mailto:ocraig@stillsecure.com]
Sent: Monday, September 17, 2007 3:50 PM
To: Adam Savage
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Slow Load time for Query Builder

On Mon, 2007-09-17 at 15:28 -0400, Adam Savage wrote:

Hi - I’m not sure if this can be answered but whenever I click on
“Tickets” and it loads the query builder it takes a while to load -
Much longer than any other options in the system…

I’m running on a HP Proliant DL365 with Fedora 7 64bit and 72gig
ultra320 15krpm mirrored Raid1+0 drives. So the hardware performance
shouldn’t be the bottleneck I would assume.

Are there any enhancements I can make to RT to make the loadtime of
the query builder faster?

Adam -
What rights have you given to RT’s large system groups? (“Everyone”
and “Privileged” are the beasts of which I speak.)

This comes up fairly often on the list, and the usual cause is that

the RT group “Everyone” has the “OwnTicket” right. Because the Query
Builder includes a drop-down select for “Owner”, RT may be building (and
your browser is rendering) a potentially enormous piece of HTML to
populate that dropdown.

If you've given "Everyone" or even just the "Privileged" group

global rights to own tickets, try removing that right and assigning it
only to the group of people within your organization who will actually
be working on tickets.

Cheers,
	Ole

/Ole Craig
Security Engineer
Team lead, customer support

ocraig@stillsecure.com
303-381-3802 main support line
303-381-3824 my voicemail
303-381-3880 fax

www.stillsecure.com

Hi Ole - here is my configuration

Everyone Current rights
CommentOnTicket
CreateTicket
ReplyToTicket

Privileged Current rights
No rights granted.

Unprivileged Current rights
No rights granted.

And then the individual groups are assigned rights etc etc.

Adam -
Hm. Might be worthwhile to make sure that this is the case for each
defined queue as well as globally.

What RT version are you running, and with which DB engine?

/Ole Craig
Security Engineer
Team lead, customer support

ocraig@stillsecure.com
303-381-3802 main support line
303-381-3824 my voicemail
303-381-3880 fax

www.stillsecure.com

I’m running 3.6.3 and the engine for my Mysql Tables is InnoDB-----Original Message-----
From: Ole Craig [mailto:ocraig@stillsecure.com]
Sent: Monday, September 17, 2007 4:03 PM
To: Adam Savage
Cc: RT-Users
Subject: RE: [rt-users] Slow Load time for Query Builder

On Mon, 2007-09-17 at 15:58 -0400, Adam Savage wrote:

Hi Ole - here is my configuration

Everyone Current rights
CommentOnTicket
CreateTicket
ReplyToTicket

Privileged Current rights
No rights granted.

Unprivileged Current rights
No rights granted.

And then the individual groups are assigned rights etc etc.

Adam -
Hm. Might be worthwhile to make sure that this is the case for each
defined queue as well as globally.

What RT version are you running, and with which DB engine?

/Ole Craig
Security Engineer
Team lead, customer support

ocraig@stillsecure.com
303-381-3802 main support line
303-381-3824 my voicemail
303-381-3880 fax

www.stillsecure.com