1. Sivaprakash BKR
  2. PowerBuilder
  3. 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

 

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 3 June 2019 16:19 PM UTC
  2. PowerBuilder
  3. # 1

Hi BKR;

  Make sure that the DW Control and/or DataStore container that runs the DWO has no code (even a comment or a blank line) on the RetrieveRow event.

Regards ... Chris

Comment
  1. Sivaprakash BKR
  2. Tuesday, 4 June 2019 10:51 AM UTC
No such code(s) in any of such events, Chris. Retrieving the dw even in the preview mode takes such time.
  1. Helpful
  1. Chris Pollach @Appeon
  2. Tuesday, 4 June 2019 17:55 PM UTC
Hi BKR;

Wow .. that is really strange!

I would now recommend adding an SQL Trace to your App, as follows:

SQLCA.DBMS = "XXX" // Change to ....

SQLCA.DBMS = "TRACE XXX"

Execute your SP based DWO and then check out what the trace tells you. It will have all the DML execution breakdown along with timings for each DBMS response.

HTH

Regards ... Chris
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.