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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.