Link to home
Start Free TrialLog in
Avatar of srinib
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
Avatar of shru_0409
shru_0409
Flag of India image

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...
Avatar of srinib
srinib

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.

ASKER CERTIFIED SOLUTION
Avatar of Lordain
Lordain

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of srinib

ASKER

..