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

Resolved PowerBuilder crashes during large data retrievals

  1. Issue
0
Votes
Undo
  1. Richard Mendez
    Richard Mendez
  2. PowerBuilder
  3. Tuesday, 21 August 2018 15:03 PM UTC

Anyone have an idea why PowerBuilder would crash on some machines but not others with the same amount of memory while retrieving large numbers of rows?

  1. PowerBuilder (Appeon)
Display and save current timestamp
Convert .NET DataTable to DataWindow BLOB
Responses (2)
Michael Kramer
Michael Kramer Accepted Answer Pending Moderation
  1. Thursday, 12 December 2019 13:36 PM UTC
  2. PowerBuilder
  3. # 1

Same physical memory is not same as same available memory.

In the "old days" (win16/win32 before 2000) Lotus Notes was known for allocating all available memory. So load sequence of apps was incredibly important. You wanted Notes to load as late as possible.

Option in DataWindow Painter > Main Menu > Rows > Retrieve Options > Rows to Disk.
This basically allows the DataWindow to save retrieved data into TEMP file to enable processing of very large result sets. Just remember that any 32-bit app has a 2 GB virtual memory limit. There is a "/3GB" option to increase that limit.

Comment
There are no comments made yet.
Leif Olsson
Leif Olsson Accepted Answer Pending Moderation
  1. Thursday, 12 December 2019 13:18 PM UTC
  2. PowerBuilder
  3. # 2

Long time no answer... 

The only tip I have is to check if the datawindow contains filters. Filter and sorting are never good to have during retrieve for performance reasons. Large amounts of data in a filter I know can cause crashes.

/Leif

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.