🚀 go-pugleaf

Yes, I want to reduce the chance of locking multiple record on the same
memory page

Desmond Leung

Replace with CA wrote in message <6jsqv7$leu$1@sue.cc.uregina.ca>...
>Hi Desmond,
>
>In article <6jo9o0$8eo$1@dover.cityu.edu.hk>,
>Desmond Leung <ckkleung@cs.cityu.edu.hk> wrote:
>>I want to know how to count the memory usage of a record?
>
>Well, if you can have a fixed text field then it's going to be
>1 character=1 byte so it's easy.  Things like integers will be 4 bytes, so
>what you then basically do is add it up.  I don't know how practical this
>would be..  Certainly I've never done it.
>
>>How can I find out this information from MDB file?
>
>You've got me there.  Since Access scrunches everything inside one big
file,
>you'd have a tough time figuring it out...
>
>You're probaby just going to have to live with multiple records being
locked
>at one time.
>
>>>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.
>--
>Jeremy Konopka             konopka at cs dot uregina dot ca