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

Resolved FYI: Max size for a DW

  1. How-to
1
Votes
Undo
  1. Olan Knight
    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.   :)  

How can I determine if a directory is empty before...
PB2022 worth the wait?
Accepted Answer
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Monday, 15 August 2022 14:58 PM UTC
  2. PowerBuilder
  3. # Permalink

UPDATE:

I have started using the little utility 4GB_PATCH.EXE pointed out by Aart below, and we migratede to PB2019R3, and between the two the issue was resolved!


PS: we are using a little tool from https://ntcore.com/?page_id=371 to allow our application to use 4GB instead of 2GB of virtual memory. When not using this tool our application crashes a lot more, so that's why we think the crashes are memory related.

Aart Onkenhout

Comment
Load more comments
Olan Knight
  1. Olan Knight
  2. Thursday, 18 August 2022 14:27 PM UTC
There are no restrictions on use listed on the developers site, so my answer is "YES, at this time".
  1. Helpful
Roland Smith
  1. Roland Smith
  2. Thursday, 18 August 2022 15:01 PM UTC
Have you tried compiling your app to 64bit?
  1. Helpful
Sivaprakash BKR
  1. Sivaprakash BKR
  2. Monday, 22 August 2022 11:36 AM UTC
No. Not yet.
  1. Helpful
There are no comments made yet.
Responses (4)
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Thursday, 22 July 2021 08:08 AM UTC
  2. PowerBuilder
  3. # 1

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
Load more comments
Chris Pollach @Appeon
  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
Miguel Leeuwe
  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
Olan Knight
  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.
Mickey Hillel
Mickey Hillel Accepted Answer Pending Moderation
  1. Monday, 26 July 2021 08:16 AM UTC
  2. PowerBuilder
  3. # 2

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
Load more comments
Miguel Leeuwe
  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
Olan Knight
  1. Olan Knight
  2. Tuesday, 27 July 2021 17:15 PM UTC
Thanks, Mickey! I am testing this now.
  1. Helpful
Olan Knight
  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.
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Wednesday, 17 August 2022 18:01 PM UTC
  2. PowerBuilder
  3. # 3

Why not compile the app as 64bit?

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.