Home arrow Discussion Forum
psadmin.org
Welcome, Guest
Please Login or Register.    Lost Password?
Query Manager Performance (1 viewing) (1) Guest
Go to bottom Post Reply Favoured: 0
TOPIC: Query Manager Performance
#203
PS Developer (Visitor)
Click here to see the profile of this user
Birthdate:
Query Manager Performance 1 Year, 5 Months ago  
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?
Enter code here   
Please note, although no boardcode and smiley buttons are shown, they are still useable
 
Logged Logged  
  Reply Quote
#204
PS (Visitor)
Click here to see the profile of this user
Birthdate:
Re:Query Manager Performance 1 Year, 4 Months ago  
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?
Enter code here   
Please note, although no boardcode and smiley buttons are shown, they are still useable
 
Logged Logged  
  Reply Quote
#205
PS Developer (Visitor)
Click here to see the profile of this user
Birthdate:
Re:Query Manager Performance 1 Year, 4 Months ago  
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.
Enter code here   
Please note, although no boardcode and smiley buttons are shown, they are still useable
 
Logged Logged  
  Reply Quote
#239
dertyl (Visitor)
Click here to see the profile of this user
Birthdate:
Ukra 2 Weeks, 3 Days ago  
Enter code here   
Please note, although no boardcode and smiley buttons are shown, they are still useable
 
Logged Logged  
  Reply Quote
Go to top Post Reply
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.