🚀 go-pugleaf

Hi Jeremy Konopka,

I want to know how to count the memory usage of a record?
How can I find out this information from MDB file?

Many Thanks,

Desmond Leung

<- Replace with ca wrote in message <6jlbjf$shc$1@sue.cc.uregina.ca>...
>In article <355e0514.0@news.piro.net>, Sascha Wostmann <s.w@gmx.de> wrote:
>>Desmond Leung wrote on Fri, 15 May 1998 18:09:24 +0800 :
>>> Does any one know how to pack an record to
>>> the same length as Microsoft jet database engine
>>> default memory page(2K) to enhance concurrency
>>> and preformance.
>>
>>just calculate the memory useage of your current records and add
>>another (text)field as long as the difference to the next 2k barrier.
>
>AFAIK, Access normally stores text null terminated so this won't work.  Ie.
>a 2048 byte record with only "Hi Bob" in it won't be stored as 2K.  You
>may be able to specify this behaviour somewhere, or worst come to worst
>you'll just have to write your own padding routine.
>
>>That doesn't work if you use memo fields, because their length isn't
>>fixed.
>
>Certainly you're right there.
>--
>Jeremy Konopka             konopka at cs dot uregina dot ca