Results 1 to 3 of 3
  1. #1
    smedvid is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2013
    Posts
    1

    Query/Table Performance Question: Field Size 255 vs Actual Size(+)

    Has anyone ever performed a benchmark against a MS Access 2007 table that has ~50,000 rows; 15 fields, most of which are Text(255)... versus re-sizing the fields to actual size (or slightly larger)? I did a quick test writing a query with group by; and saw only a ~1 second difference for ~50,000 rows. I really expected to see a better performance. Looking for justification to optimize and re-size DB tables, and need to prove performance gain. Any comments welcomed. tia,

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    I always wondered if field size made any difference. I was inclined to think not with modern computer processors. Maybe it does with Memo type.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    From M$oft

    Note For data in a Text field, Access does not reserve space beyond what is necessary to hold actual values. The Field Size property is the maximum field value size.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Performance and Size of Table, SQL Server
    By EddieN1 in forum Access
    Replies: 7
    Last Post: 01-17-2013, 04:17 PM
  2. Replies: 3
    Last Post: 07-19-2012, 09:27 AM
  3. Setting Field Size in a New Table
    By vinfurnier in forum Access
    Replies: 2
    Last Post: 11-15-2011, 10:37 AM
  4. Reduce field size in query field
    By escapades_access in forum Queries
    Replies: 9
    Last Post: 03-13-2011, 12:21 PM
  5. Replies: 4
    Last Post: 07-28-2010, 10:27 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums