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 ?