Sergey
That's excellent, thanks.
Kev
>Hi Kevin,
>
>It's easy to calculate Max # of record using HEADER() and RECSIZE() functions
>
>ln2Gb = 2*1024*1024*1024
>USE mytable
>lnMaxRecs = FLOOR( (ln2Gb - HEADER() -1 ) / RECSIZE() )
>
>
>>Been a while since I posted on here, hope everyone is keeping well.
>>
>>I'm writing an app and due to the large amounts of data it's going to be storing I need to be careful about the 2Gb table limit.
>>
>>2 questions really:
>>
>>a) Is it possible to project table-size, if I have a table with say, 4 columns, would I be able to get a "rough" idea of how many records it will populate without reaching the limit?
>>
>>b) Secondly, I want to ensure that the 2Gb limit won't be reached, what's the best way to ensure it doesn't reach it? If there is an answer to question a then I'll keep an eye on the record count, however if this is not possible I'll need some other mecahanism.
>>
>>Thanks
>>Kev