Welcome to SPN

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

Sign Up Now!

Structure - Which Way Is Best

Discussion in 'Information Technology' started by Nathan, Jul 28, 2006.

  1. Nathan

    Expand Collapse

    I have a DB that controls what is essentially 4 different sets of data. Each
    set will eventually be in 1000s of records. The front end uses different
    forms to access and manipulate the data.

    Is it better to keep all the data in one table, or spread it out across four
    different back-ends. They are seperate now only because there used to be
    different front ends as well. Is there a speed difference? Data integrity?


  2. Loading...

    Similar Threads Forum Date
    Structure Of The Guru Granth Sahib New to Sikhism May 30, 2016
    Heritage 16th-century Sikh Structures Identified For Preservation In Tarn Taran History of Sikhism Mar 10, 2015
    SciTech Meditation And Brain Structure Breaking News Jan 7, 2014
    World Toilet Trouble: New Technology And Infrastructures With Dr. Doulaye Kone Breaking News Oct 26, 2013
    General Management Structure Of Sikh Religion And The Preaching Class History of Sikhism Mar 30, 2013

  3. OP

    Expand Collapse

    Considerations - not relating to speed:

    1) Probably, currently you don't have queries across mdbs, But if and
    or after you end up creating those queries, what will happen to your
    data integrity if one of those mdbs has to be set back to a backup, but
    the other three not. On the surface, that is the only thing that I
    would worry about, but I have not had to do that, yet, so I haven't
    given it too much thought.
Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     

Share This Page