- Sivaprakash BKR
- PowerBuilder
- Monday, 3 June 2019 08:15 AM UTC
Hello,
Using Pb 11.5, Sql Server 2012 express
Got a datawindow retrieving data through a stored procedure from the database. Suddenly it's taking more time to retrieve.
when the same query is executed in the SSMS, it takes only a couple of seconds to retrieve.
when the same query is used to construct a datawindow, it takes only a couple of seconds to retrieve.
But when used to retrieve through the stored procedure it takes more time ( varies between 16 seconds to 25 seconds) to retrieve the same data.
All Tested from the same machine where database and program is stored.
What could be cause for this delay ? Any suggestions ?
Happiness Always
BKR Sivaprakash
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.