Groups | Search | Server Info | Login | Register

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

Re: Saving memory

Show all headers | View raw

Thanks, but that's not the case as this BE gets compacted everyday when the 
first user logs in and the BE size gets logged, so I can precisely check the 
size.

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.

Martin

"Douglas J Steele"  schreef in bericht news:in9pv5$sf$1@dont-email.me...

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