Sabtu, 17 September 2011

Re: [MS_AccessPros] I just want to verify text field size work as I think they do, feed back plz

 



Hi Terence,

I change the default to 50.  It is set it that big, imo, for those who don't know how to make it small so the field has less chance of being too small

Even 50 is too big for many fields.  My testing has shown that performance benefits from smaller text fields.

There are some who will tell you that it does not matter since variable length text is stored ... but it does.  Compact/Repair your database. Then shorten text fields (but not any actual data) in tables that have lots of records -- when you C/R again, you should notice a difference.  It also makes a difference in performance.  I have had situations where complex queries linked on text fields would not run until the allowable field size in the table design was made smaller.

Warm Regards,
Crystal

www.Youtube.com/LearnByCrystal

 *
   (: have an awesome day :)
 *

----- Original Message -----
From: Terence

As I understand it:
Access 2007, the default is that a text field in a table default to 255 characters unless you change the default.

That means that as I create a filed in a table and set its size paramet to ..say 50....I do indeed get a size of 50 characters, and thus a disk space saveings ?

Terence

__._,_.___
Recent Activity:
MARKETPLACE
A bad score is 579. A good idea is checking yours at freecreditscore.com.

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

Tidak ada komentar:

Posting Komentar