Maximum size of temp table

saravanakumar

saravanakumar

Member
Hi Everybody,
Can anyone give me the maximum size of temp table in Progress 10.0B? Is there a way to find it very easily?

Can anybody help me out in this issue?

Thanks in advance!!
 
Thank u very much Casper.
I got the required answer. I had some performance issues with this and now i have got it clear.
Thanks.

But one thing do we have any way to find the size through piece of code?
 
Likewise i need to know one thing, they have mentioned the maximum size as 2 GB. Is it constant across all versions. Bcoz i need it specifically for Progress 10.0B.
Correct me if i am wrong.
 
2 GB sounds to me a 32 bit thingy. So maybe its different for 64 bit versions.
There is no further information regarding to version. So I don't know that.

Nevertheless 2GB sounds an awfull lot for temp-tables. And one can question if any bigger temp-tables are still usefull.

Temp-tables reside in memory (which is governed by the -Bt parameter) any overflow is written to the dbi file. So the size of the dbi file + -Bt is an indication of the size of your temp-table.

Casper.
 
You must log in or register to reply here.
Back
Top