PeopleTools was upgraded from 8.46 to 8.49. Ever since the upgrade went through, Web Query access for users has become really slow.

It's not query performance but clicking on a navigation link like Reporting Tools > Query Viewer takes ages to load. Same with Query Manager and navigating within Query Manager.

Tried logging in using BATCH, and the delay happened a couple of times but generally it was fast.

Any one have come across anything similar to this before? Any thoughts?

if the query is running frm 2 tier without any issues it shld also run from web.

ensure max fetch size for PSAPPSRV and PSQRYSRV are set appropriately.

along with tools upgrade did you also upgrade ur DB release?

The max fetch size is the same from the old version. Is there a recommended value or is the value determined based on load?

We did not upgrade our DB - it's only tools.

We have been playing around with the Query Access List Cache. Apparently the caching turns itself off - it's known that it turns itself off if a role based change is done to the system, but we weren't able to replicate it. As for now we're checking every now and then to see if it's still on or no.

Hi http://snowstormlife.Com/members/2010fordescapehybrid.Aspx 1? http://snowstormlife.Com/members/usedfordescapehybrid.Aspx