Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Table size getting large...

Discussion in 'Information Technology' started by Access Sortof Newb, Jul 28, 2006.

  1. Access Sortof Newb

    Access Sortof Newb
    Expand Collapse

    Good morning,

    I have a table that currently has about 3500 records, but this number
    will be increasing substantially over the next few months to about
    10000+ records. The table holds details for bills of materials for
    electronic component assembly. The table has the following fields:

    BOMID: The BOM that the detail is associated with
    Part Number: The part number for the specific reference locator
    Location: The reference locator

    The problem is that when one of the products gets revised I have to
    reenter the entire BOM, causing multiple duplicate fields every time
    this happens. I was wondering if anybody has an idea that I could use
    to make sure this table does not explode in size simply due to
    revisions and duplicated data.


  2. Loading...

    Similar Threads Forum Date
    As A Child, Public Marches Of Sikhism Made Me Uncomfortable. They Still Do . Why ? Whats The Logic Hard Talk Oct 16, 2016
    Arts/Society Backyard Vegetable Garden Language, Arts & Culture Dec 27, 2013
    Heritage Now a Vegetable Market, Ranjit Singh's Royal Haveli a Picture of Neglect History of Sikhism Nov 11, 2013
    Sikhism Helium: 1984 and the "Periodic Table of Hate" (Jaspreet Singh) Book Reviews & Editorials Oct 28, 2013
    Heritage How our entire history was dumped in a horse stable History of Sikhism Oct 28, 2013

  3. Nikos Yannacopoulos

    Nikos Yannacopoulos
    Expand Collapse


    I would focus on business needs first, rather than worry about the table
    size. If that's the way it works best for you then leave it as is, the
    table size you are looking at is no big deal!
    Just for comparison, I have over two hundred thousand rows in an invoice
    headers table, with close on a million rows in the related line items
    table; it's a shared back end on a network with about a dozen concurrent
    users, and it works just fine. Contrary to common misconceptions, Access
    is not a toy! It can handle large quantities of data (up to 2GB file
    size) as long as the overall design is good.

Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     

Share This Page