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

Resolved Data Window Performance Issues

  1. Issue
0
Votes
Undo
  1. Gordon Leishman
    Gordon Leishman
  2. PowerBuilder
  3. Wednesday, 13 December 2017 07:36 AM UTC

Hi all,

I'm having Data Window performance issues on users machines.

Where a data window retrieves a large amount of data, it will retrieve the data from the DB fast but will then freeze when the user tries to click anywhere inside the window, whether that be on a field or trying to scroll.

It will hang for a while and the application will show not responding.  The length of the hang time correlates to the amount of data in the data window.

Once it comes out of the hung state the data window then operates as normal with now no hanging or lag time.

When the user then exits the data window the application hangs once more for around the same amount of time.

Most of our Data Windows require from and to date parameters for the users to narrow down their results, so they are able to workaround the issue by narrowing the date range.

I'm assuming it is memory related as the issue does not occur on my dev machine which has 16GB RAM, whereas he users machines only have 8GB.

Has anyone experienced the same issue? Does anyone have any ideas on how I could fix this, without adding memory to the users machines.  

I am on PB 2017 connecting to SQL Server 2012 using ODBC.  

Thanks
Gordon

  1. Data
  2. Performance
  3. PowerBuilder
The SoapClient doesn't support .NET proxy error
INVALID RESULTSET PARAMETER TYPE WAS DETECTED (CON...
Responses (3)
Clarence Chamorro
Clarence Chamorro Accepted Answer Pending Moderation
  1. Thursday, 28 December 2017 20:49 PM UTC
  2. PowerBuilder
  3. # 1

If you have one or two calculated columns in your SQL data source the retrieval will take longer. Specially if your are doing Multiplication or Division.

One way to solved your issue is by using Row -> Retrieve Options -> Rows As Needed. This may Help.

Regards,

Clarence.

Comment
There are no comments made yet.
Matthew Balent
Matthew Balent Accepted Answer Pending Moderation
  1. Wednesday, 13 December 2017 13:55 PM UTC
  2. PowerBuilder
  3. # 2

If you have scripts and/or global functions within the columns in a datawindow (changing properties or calculating something) performance may suffer.

Comment
There are no comments made yet.
Marco Meoni
Marco Meoni Accepted Answer Pending Moderation
  1. Wednesday, 13 December 2017 09:29 AM UTC
  2. PowerBuilder
  3. # 3

Hi Gordon,
possible reasons for slow down and freezing are:

- heavy scripts running in the retrieverow/retrieveend events (especially if running additional SQL)
- (large) dropdown-datawindow in DW columns

Cheers,

Marco

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.