PSADMIN.org - Administrator

FeedBurner
Get Postings by Email without Account.

Who's Online
We have 18 guests online

	psadmin.org	Forum Show latest posts

Welcome, Guest
Please Login or Register. Lost Password?

Administrator (1 viewing) (1) Guest

Post a new message in "Administrator"

Name:

Subject:

topic icon:

Boardcode:

Colour: Size: Close all tags

Message:

preview:

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?