• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Doing a selectrow() on a large result set is very slow.

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (4)

Resolved Doing a selectrow() on a large result set is very slow.

  1. Issue
0
Votes
Undo
  1. Arun Kumar
    Arun Kumar
  2. PowerBuilder
  3. Monday, 30 October 2017 14:31 PM UTC

I am trying to retrieve 98k rows in free form dw control. The dw is being shared with a grid dw. 
It takes around 40 seconds to retrieve the data. Once the data has  been retrieved. When i click on the grid dw, we are doing selectrow(0, false) and selectrow(row, true). In both the cases of selectrow() powerbuilder seems to hang for 2 seconds. What might be causing this? On a smaller result set it's very quick and instant. 
Also, the memory peeks to nearly 550 MB during the retrieval. Could that be the cause?

Below's my current environment.

OS - Windows 10, Windows Server 2012 

DB - SQL Server 2016. 

Powerbuilder 12.5.2 

EDIT:

Below is the trace information. 

  1. Build
Use PowerBuilder from .Net project?
PowerBuilder 12.6 can't detect .Net Framework 4.6....
Responses (4)
Georgios Papageorgiou
Georgios Papageorgiou Accepted Answer Pending Moderation
  1. Friday, 3 November 2017 10:32 AM UTC
  2. PowerBuilder
  3. # 1

Do you have any conditional expression in the datawindow ?

and maybe even expression calling a global function ?

/Georgios

 

Comment
There are no comments made yet.
George Mikhailovsky
George Mikhailovsky Accepted Answer Pending Moderation
  1. Monday, 30 October 2017 15:45 PM UTC
  2. PowerBuilder
  3. # 2

I would check if your DataWindow is set to multi-select and turn this off if this is not necessary. Then, I would try to call GetRow() function and then use a value that it returns in SelectRow() function monitoring which of the functions produces the 2" hanging.

 

Comment
Arun Kumar
  1. Arun Kumar
  2. Wednesday, 1 November 2017 10:52 AM UTC
Can you take a glance at the screenshot of the Trace View and help me in the correct direction?

  1. Helpful
There are no comments made yet.
Ashutosh Varshney
Ashutosh Varshney Accepted Answer Pending Moderation
  1. Monday, 30 October 2017 15:43 PM UTC
  2. PowerBuilder
  3. # 3

You should debug and see what is going on behind the scenes - maybe you have code in the rowfocuschanged event which is causing the delay or you have set retrieve as needed? There could be a lot of possible causes. It might also come down to having too many rows and your system is struggling.

HTH.

Comment
There are no comments made yet.
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Monday, 30 October 2017 15:32 PM UTC
  2. PowerBuilder
  3. # 4

Maybe you shouldn't be retrieving all those rows.

Comment
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.