Groups > comp.databases.ms-access > #776

Saving memory

From	<martin@hotmail.com>
Newsgroups	comp.databases.ms-access
Subject	Saving memory
Date	2011-04-03 10:46 +0200
Message-ID	<49923$4d9833db$5356be6c$3062@cache120.multikabel.net> (permalink)
Organization	Multikabel

Show all headers | View raw

I'm converting my hyperlink fields to standard text fields. Since the 
hyperlink field stores (part of) the info twice, like MyFile.doc 
#C:\MyFile.doc#, I expected to save some memory. In my 20MB backend I have a 
3 field table with a hyperlink field (about 10.000 records) and 2 ID fields. 
After converting the hyperlinkfield to a text field (taking only the display 
part), the backend is now 1,6 MB smaller. I can't imagine that it's only the 
extra text the hyperlink fields stores. Is there some additional info stored 
which made the backend smaller?

Thanks,
Martin

Back to comp.databases.ms-access | Previous | Next — 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