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

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

    Guys,

    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?

    Thanks

    Aboo

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    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
    Location
    Adelaide, South Australia
    Posts
    4,049
    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
  •