Re: Saving memory

From	Tony Toews <ttoews@telusplanet.net>
Newsgroups	comp.databases.ms-access
Subject	Re: Saving memory
Date	2011-04-03 18:22 -0600
Organization	Me? Organized? Not a chance.
Message-ID	<983ip6p35eoehndp87ce9d4buquchspd4n@4ax.com> (permalink)
References	<49923$4d9833db$5356be6c$3062@cache120.multikabel.net> <in9pv5$sf$1@dont-email.me> <2b3a7$4d987872$5356be6c$10034@cache120.multikabel.net>

Show all headers | View raw

On Sun, 3 Apr 2011 15:38:51 +0200, <martin@hotmail.com> wrote:

>The hyperlinkfield wás indexed though along with an ID field and so is the 
>text field now with the same ID field. I'm guessing the extra text of the 
>hyperlink took a lot of extra storage room.

Ah, so you're surpised the BE is now 1.6 Mb smaller.   You expected a
smaller decrease in size?

Hyperlink fields are stored similar to memo and OLE fields in that
each field with data becomnes a separate 4 kb page.  (At a minimum.
Obviously a memo or OLE field could be larger as well as a hyperlink
field.  Although that might be a rather long hyperlink.  )

Thus I would expect 10K records at 4 Kb each to take 4 Mb in the old
format.   

But then 10K records with 255 bytes each might take 255 Kb extra
space.   Although that's not at all an accurate space calculation
because multiple records can fit in a 4 Kb page and thus many of those
now text fields might've fit in the current page without any problems.

But my WAG calculations are clearly wrong in some respect.  I'm not
quite sure why but you get the idea.   Did all 10K records have a
hyperlink or maybe only abuot 1.6/4 or about 40%?

Tony
-- 
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files 
  updated see http://www.autofeupdater.com/

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Saving memory <martin@hotmail.com> - 2011-04-03 10:46 +0200
  Re: Saving memory "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_gmail.com> - 2011-04-03 08:42 -0400
    Re: Saving memory <martin@hotmail.com> - 2011-04-03 15:38 +0200
      Re: Saving memory Tony Toews <ttoews@telusplanet.net> - 2011-04-03 18:22 -0600
        Re: Saving memory <martin@hotmail.com> - 2011-04-04 16:53 +0200

csiph-web