1. Olan Knight
  2. PowerBuilder
  3. Wednesday, 21 July 2021 23:24 PM UTC

PB2019R2, b2703
Windows 10 64 bit platform
Client/Server application
No framework
Small, single PBL utility


We have determined empirically that in our environment, listed above, the max size of a dw_output before it either locks up, or locks up then abends the application, is:
         650,000 rows, from a 210 bytes-per-row input file
                              saved into dw_output defined with 23 columns as follows:


Note:  Several of the columns can be written/appended to during processing, hence their size.
          All input files are 210 bytes per row.




YMMV.   :)  

Mickey Hillel Accepted Answer Pending Moderation
  1. Monday, 26 July 2021 08:16 AM UTC
  2. PowerBuilder
  3. # 1

Check out this property for your datawindow.

https://docs.appeon.com/pb2019/datawindow_reference/ch03s03.html#XREF_81831_StoragePageSize

I think that 

dw1.Modify("datawindow.storagepagesize='LARGE'")

should be able to fix the DW limation that you have encountered

regards,
Mickey

 

Comment
  1. Miguel Leeuwe
  2. Tuesday, 27 July 2021 06:45 AM UTC
Hi, see: https://www.appeon.com/standardsupport/search/view?id=7001

There's not much difference between LARGE and MEDIUM (and Default), according to Appeon.

regards
  1. Helpful
  1. Olan Knight
  2. Tuesday, 27 July 2021 17:15 PM UTC
Thanks, Mickey! I am testing this now.
  1. Helpful
  1. Olan Knight
  2. Wednesday, 28 July 2021 19:36 PM UTC
Well, this did not seems to make a difference in the processing. The app froze in the same location as it did prior to adding the property. :(



  1. Helpful
There are no comments made yet.
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Thursday, 22 July 2021 08:08 AM UTC
  2. PowerBuilder
  3. # 2

Hi Olan,

It's all about how much RAM you have available. If it's a 32 bit executable or when running from the IDE, your app can only use 2 GB of memory. (there's a way of 'tricking' windows to let it have 3 GB, but that's the max.).

If you have more RAM and you'd build a 64 bit executable, the amount of rows you can retrieve will significantly increase.

regards.

Comment
  1. Chris Pollach @Appeon
  2. Friday, 23 July 2021 23:17 PM UTC
Hi Olan!

You can try this ...

http://www.windowscentral.com/how-change-virtual-memory-size-windows-10?amp

Regards ... Chris
  1. Helpful
  1. Miguel Leeuwe
  2. Saturday, 24 July 2021 20:03 PM UTC
Hi Olan, If you are referring to the "3 GB trick", there's this article by Yakow Verde:

https://community.appeon.com/index.php/articles-blogs/tutorials-articles/2-powerbuilder/142-breaking-platform-limitations

  1. Helpful
  1. Olan Knight
  2. Tuesday, 27 July 2021 18:18 PM UTC
Thank you for the tips, guys!
  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.