Re: Saving memory

From	"Douglas J Steele" <NOSPAM_djsteele@NOSPAM_gmail.com>
Newsgroups	comp.databases.ms-access
Subject	Re: Saving memory
Date	2011-04-03 08:42 -0400
Organization	A noiseless patient Spider
Message-ID	<in9pv5$sf$1@dont-email.me> (permalink)
References	<49923$4d9833db$5356be6c$3062@cache120.multikabel.net>

Show all headers | View raw

I'm guessing you also did a compact when you did the deletion, and you 
hadn't done one for a while.

wrote in message 
news:49923$4d9833db$5356be6c$3062@cache120.multikabel.net...

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 — 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