Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Text Attribute Size Allocation

  Asked By: Parvesh    Date: Sep 08    Category: Sharepoint    Views: 837

For attributes that accept single or multi-line text input, does
SharePoint internally use more storage if the attribute size is
specified larger than needed? Or, does SP dynamically allocate the
size as needed? Is there any performance impact of over-sizing a
field? Is there a recommended maximum size? Some of our attributes
will contain text whose character length is not known in advance.



1 Answer Found

Answer #1    Answered By: Alisha Itagi     Answered On: Sep 08

This is really a SQL question

The amount of space you reserve will be the amount of space you reserve

If you reserve 4 byte of space for a million rows of data you will take
up 4 million bytes of hard drive space - if you reserve double this you
will use up twice as much 8 million bytes

Not too much difference, I know

However, if you then have a huge number of sites this can grow.

However, that's not the real killer as hard drive space is cheap. What
really hurts is when you start to query this data - a difference between
4Mb and 8Mb of data returned by a query is not a lot BUT if you have
1,000 people performing the same or similar queries against that data
then you will get a severe impact  on sql in terms of memory.

If I had to give advice it would be to reserve the right amount of stuff
and use correct data types for each column. However, if you only have a
small implementation on highly specced equipment it wouldn't make too
much difference as you can see. I guess it all depends upon your
environment but the techie advice is always to reserve the right amount
of space.

Didn't find what you were looking for? Find more on Text Attribute Size Allocation Or get search suggestion and latest updates.