Home arrow Discussion Forum
psadmin.org
Welcome, Guest
Please Login or Register.    Lost Password?
Administrator (1 viewing) (1) Guest
Post a new message in "Administrator"
Name:
Subject:
topic icon:
no
Boardcode:
 Colour:  Size:   Close all tags
Message:
 Enter code here   

Topic History of: Query Manager Performance
Max. showing the last posts - (Last post first)
Author Message
PS Developer 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.
PS 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?
PS Developer 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?
Powered by PsAdmin.orgget the latest posts directly to your desktop
© 2010 PSADMIN.org
PSAdmin.org is for & by the PeopleSoft Administrators to share their Experience.