[rt-users] Create.html very slow to load
Myers, Adam
AMyers at abacus-us.com
Tue Nov 29 13:13:42 EST 2005
The only global rights allowed to Everyone is ModifySelf. Users are not
granted global rights and only get rights from groups they belong to.
** Adam Myers
-----Original Message-----
From: Drew Barnes [mailto:barnesaw at ucrwcu.rwc.uc.edu]
Sent: Tuesday, November 29, 2005 10:26 AM
To: Myers, Adam
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] Create.html very slow to load
Check your global rights. I suspect that you have assigned Everyone the
OwnTicket right, perhaps as an oversight.
Myers, Adam wrote:
> That is what's bewildering me right now is that all users are brand
> new and are not apart of any group or have any rights granted. There
> are only about 15 users right now that have the right to own a ticket.
>
>
> ** Adam Myers
>
> -----Original Message-----
> From: Drew Barnes [mailto:barnesaw at ucrwcu.rwc.uc.edu]
> Sent: Tuesday, November 29, 2005 10:13 AM
> To: Myers, Adam
> Cc: rt-users at lists.bestpractical.com
> Subject: Re: [rt-users] Create.html very slow to load
>
>
>
> Myers, Adam wrote:
>
>>
>>
>>> |< Reply to myself
>>>
>>
>> I found that since I added all my companies users to the DB, the page
>> takes a long amount of time to run the 'SelectOwner' component. It
>> is
>>
>
>
>> querying to see WhoHasRight to own a ticket in that queue. This
>> searches only 378 users, so every time that component is called it
>> will take about 20-30 seconds to load.
>>
>
> Do all 378 users need to OWN tickets, or just be requestors? That's
> the quickest way to prune the load time.
>
>
>>
>> Is there a way to speed up this query? I can remove the option to
>> SelectOwner on ticket creation, not many people do that anyways. But
>> when a ticket needs a watcher or owner assigned, it will hang for a
>> while which is not good.
>>
>> Please help
>>
>> Adam
>>
>> ---------------------------------------------------------------------
>> -
>> --
>> *From:* rt-users-bounces at lists.bestpractical.com
>> [mailto:rt-users-bounces at lists.bestpractical.com] *On Behalf Of
>> *Myers, Adam
>> *Sent:* Tuesday, November 29, 2005 9:38 AM
>> *To:* rt-users at lists.bestpractical.com
>> *Subject:* [rt-users] Create.html very slow to load
>>
>> Hello,
>>
>> I am running RT 3.4.4 on Solaris 10, Apache 1.3.34 w/mod_perl, Oracle
>>
> 9.
>
>>
>> I recently released RT into production and all is well, except now
>> when I select a queue and click to create a new ticket, RT hangs for
>> a
>>
>
>
>> while and does not load "Create.html" for about 30 seconds. My
>> development version does not do this so the only reason I can think
>> of
>>
>
>
>> is the database backend. This is the only difference between prod
>> and
>>
>
>
>> dev.
>>
>> I am in a bind because my dev/test box works great, and I can't shut
>> down production to debug. I have 18 queues in the DB and all other
>> pages that have to do with loading from the queues table loads fine.
>>
>> Any ideas would be very helpful.
>>
>> Thanks - Adam Myers
>>
>> ---------------------------------------------------------------------
>> -
>> --
>>
>> _______________________________________________
>> 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
>>
>
> --
> Drew Barnes
> Applications Analyst
> Raymond Walters College
> University of Cincinnati
>
--
Drew Barnes
Applications Analyst
Raymond Walters College
University of Cincinnati
More information about the rt-users
mailing list