Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006

    Unanswered: what are the effects of having a huge table?


    I have a catalogue of items that i want to store in a table. it will be around 10,000 items. If i have several of these tables will it drastically effect the performance of my database? if so what are the possibilities?



  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    access tends to get a little bit gutless around the 2gb file size or multi million row level.

    however warning lights start to flash when you say you have several of these tables... that makes me think there is a problem with your table design. I'd expect one table design catering for products, and possibly sub table(s) to differentiate if required. multiple tables for categories suggests the design isn't right
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Nov 2007
    Adelaide, South Australia
    I think there is a max file size for Access at about 1.7GB. Once you start nearing a million records in a table in Access, it is well time to consider upsizing. 10,000 records is not a lot though.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts