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

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. Ron2006

    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...

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