1. Sivaprakash BKR
  2. PowerBuilder
  3. Monday, 03 June 2019

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 Accepted Answer Pending Moderation
0
Votes
Undo

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
No such code(s) in any of such events, Chris. Retrieving the dw even in the preview mode takes such time.
  1. Sivaprakash BKR
  2. Tuesday, 4 June 2019
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. Chris Pollach
  2. Tuesday, 4 June 2019
There are no comments made yet.
  1. Monday, 3 June 2019
  2. PowerBuilder
  3. # 1
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.