srinib
asked on
Powerbuilder Datawindow Report performance Issue
I have a report designed in Powerbuilder using datawindow source as SQL. This report retrieves fast in 5 seconds in development PCs. The same report takes 4 mins to retrieve in QA PCs. We all connect to same database and server.
What could be the issue?
Is it a local desktop configuration perofrmance issue? OR local Sybase cleint protocols issue?
Any Ideas?
Thanks
Srinivas
What could be the issue?
Is it a local desktop configuration perofrmance issue? OR local Sybase cleint protocols issue?
Any Ideas?
Thanks
Srinivas
its depend upon the data...compare to QA PCs may be less data available in ur development PCs that wise it will take time. check the plan and use the proper hints or rebuild ur index...
ASKER
Test criteria is same, means test conditions,volume of data, database,server connections all same.
Infact we all connect to the same QA environment, no difference in connections and volume of data.
Infact we all connect to the same QA environment, no difference in connections and volume of data.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
..