[AccessD] notes on mdb bloat

Hi Seth et all

In Garry Robinson's newsletter I noted this extremely interesting topic:


SINGLE RECORD LOCKING, BLOAT AND CITRIX BUGS
 
Did you know that the record-level locking option (menu
Tools~Options~Advanced) that is used by Access 2000 onwards has an
interesting twist. To achieve a single record lock, each record that
is locked uses up all of an Access page in the mdb file. This page of
data, most of which will probably be empty for records with only a few
fields, consumes 4000 bytes. This space is later recovered when the
database is compacted but if you have a database that seems to expand
fast, this could be your culprit. For more on this database bloat and
a possible cure for Access corruptions for Citrix head to this page.

http://ewbi.blogs.com/develops/2004/01/access_corrupti.html
 
and an other blog on the same topic
http://dbforums.com/arch/213/2002/10/551337

Gary is here:

http://www.vb123.com/

/gustav


> I hadn't even thought of that.  I tried it just now, and the resulting
> mdb is 1.5MB.  Still three times as big as the A97 version, but not as
> big as the base A2K version.

> The unicode comments make sense, I had forgotten about that, too.

> Oh well, more interesting info from the developer front...

> Seth

> On Wed, 2003-03-12 at 11:45, Gustav Brock wrote:
>> Hi Seth
>> 
>> What happens if you "forward port" the A97 version to A2000?
>> 
>> /gustav