Is there a max size for a blob?
PB Classic 12.5.1 build 4015
Is there a max size for a blob? Documentation says "unbounded", but I'm seeing problems.
Before starting, I will mention that I have already sent the email about why we have so much data in a datawindow anyway and there are probably better ways to accomplish what the users want, but I'm still curious.
We use GetFullState/SetFullState to move a report between objects in different threads. I don't know the exact limit I'm running up against, but the GetFullState command succeeds when the resulting blob is 30Mg and under, but hangs when I estimate the result should be about 150Mg.
A GenerateResultSet succeeds on the same datawindow and I tried to modfiy our system to use that instead, but it doesn't get all the data from nested reports (unless I'm just not using it right).
The machine I'm testing with has 16Gg memory but less than 4Gb used while running this.
Bruce Armstrong replied
You might try running the 4GB batch tool on your PowerBuilder executable (the not IDE, but on the executable you generate from PB). It turns on the LARGEADDRESSAWARE flag so your 32 bit app can see 4GB on a 64 bit system: