A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Memo Field Size



 
 
Thread Tools Display Modes
  #1  
Old November 19th, 2004, 05:15 PM
AdmSteck
external usenet poster
 
Posts: n/a
Default Memo Field Size

How much memory is needed to store memo fields? Would it be more efficient
to create a large text field?
  #2  
Old November 19th, 2004, 07:10 PM
Rick Brandt
external usenet poster
 
Posts: n/a
Default

"AdmSteck" wrote in message
...
How much memory is needed to store memo fields? Would it be more efficient
to create a large text field?


In a memo field all that is stored in the table is a pointer to the actual data
stored elsewhere on disk (still within your file). The amount of space consumed
should be the amount of your data plus the small amount for the pointer. If you
need more than 255 characters then a Memo field is the appropriate choice.

The more "real" issue with Memo fields in Jet tables is that they can be prone
to corruption so you should be prudent with them. I usually ask my users if
they _really_ need more than 255 characters before I use them.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


  #3  
Old November 19th, 2004, 07:21 PM
John Vinson
external usenet poster
 
Posts: n/a
Default

On Fri, 19 Nov 2004 08:15:05 -0800, "AdmSteck"
wrote:

How much memory is needed to store memo fields? Would it be more efficient
to create a large text field?


A Text field is limited to 255 bytes, so there's no such thing as a
"large text field". A Memo stores as many characters as are entered
into the field, plus a 16-byte overhead no matter the size of the memo
field. Thus if you have 40 bytes in the memo field, it will take up 56
bytes on disk; if you have 40,000 bytes, it will take up 40,016 bytes.

If you don't need more than 255 bytes, use Text; text fields are more
efficient, they can be indexed, and they're less subject to corruption
than Memos.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
  #4  
Old November 19th, 2004, 07:23 PM
AdmSteck
external usenet poster
 
Posts: n/a
Default

Ok, do text fields store the same way, or do they always allocate the field
size whether it is used or not?

"Rick Brandt" wrote:

"AdmSteck" wrote in message
...
How much memory is needed to store memo fields? Would it be more efficient
to create a large text field?


In a memo field all that is stored in the table is a pointer to the actual data
stored elsewhere on disk (still within your file). The amount of space consumed
should be the amount of your data plus the small amount for the pointer. If you
need more than 255 characters then a Memo field is the appropriate choice.

The more "real" issue with Memo fields in Jet tables is that they can be prone
to corruption so you should be prudent with them. I usually ask my users if
they _really_ need more than 255 characters before I use them.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com



  #5  
Old November 19th, 2004, 09:54 PM
Rick Brandt
external usenet poster
 
Posts: n/a
Default

"AdmSteck" wrote in message
...
Ok, do text fields store the same way, or do they always allocate the field
size whether it is used or not?


Access Text fields are variable length (unless you go out of your way to make
them fixed width) They only consume as much space as the characters stored in
them (plus a little more). So a 255 character field with only 10 characters
entered in it does use less disk storage than if you had entered 50 characters.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MEMO FIELD SEAN Database Design 3 October 1st, 2004 04:33 AM
If Statement for Memo Field Dave Elliott Using Forms 1 September 20th, 2004 05:26 PM
Memo Field data truncated in query Joel Running & Setting Up Queries 3 August 4th, 2004 03:40 PM
size of memo field Frank General Discussion 7 July 8th, 2004 10:51 AM


All times are GMT +1. The time now is 10:54 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.