Welcome to SPN

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

Sign Up Now!
  1. Guest ji, please consider donating today!
      Become a Supporter    ::   Make a Contribution   
    Monthly Recurring Target: $300 :: Achieved: $95

Should I break down this kind of Table? >.<

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

  1. Cicada

    Cicada
    Expand Collapse
    Guest

    1st table'sFormat is like this:
    Book_Index Translation1 Translation2 ... Translation5
    <Integer> <Memo> <Memo> <Memo>

    There are total 40,000 records x above 6 fields.
    Number of Translations are always fixed and equal for each record, not
    variable.
    Importances of each Memo are equal.

    In my Form & Report, I will output both format:
    1. Index + Single Translation
    2. Index + Multi Translation

    2nd Format:
    Break 1st table into 5 tables (One index with one translation only - 2nd
    Format)

    For 1st Format, it is good for later multi-Translation output, since I only
    need to do index-matching by once, not "multiple". This speed up the
    operation.

    But I am not familiar with internal operation of Database & SQL. Will they
    load WHOLE table during each operation (searching, ...), or just load my
    assigned fields?

    If former is the answer, then 1st Table will consume too much memory and may
    conversely slow down the operation.
    Then, I can only choose 2nd Table"s" format.

    N.B. I am using an application similar to MS Access, but it can access one
    Database in the same moment only. Therefore, all Tables and Forms are always
    stored in the same file.
     
  2. Loading...


  3. Terry Kreft

    Terry Kreft
    Expand Collapse
    Guest

    To me both your structures are wrong.

    You should have 2 tables

    Table1: Books
    Book_Index (PK)
    Book_Title
    etc.

    Table2: Translations
    Book_Index (PK)
    Language (PK)
    Translation



    --

    Terry Kreft


    "Cicada" <patwwh@hotmail.com> wrote in message
    news:upX2KpBnGHA.4172@TK2MSFTNGP03.phx.gbl...
    > 1st table'sFormat is like this:
    > Book_Index Translation1 Translation2 ... Translation5
    > <Integer> <Memo> <Memo> <Memo>
    >
    > There are total 40,000 records x above 6 fields.
    > Number of Translations are always fixed and equal for each record, not
    > variable.
    > Importances of each Memo are equal.
    >
    > In my Form & Report, I will output both format:
    > 1. Index + Single Translation
    > 2. Index + Multi Translation
    >
    > 2nd Format:
    > Break 1st table into 5 tables (One index with one translation only - 2nd
    > Format)
    >
    > For 1st Format, it is good for later multi-Translation output, since I

    only
    > need to do index-matching by once, not "multiple". This speed up the
    > operation.
    >
    > But I am not familiar with internal operation of Database & SQL. Will they
    > load WHOLE table during each operation (searching, ...), or just load my
    > assigned fields?
    >
    > If former is the answer, then 1st Table will consume too much memory and

    may
    > conversely slow down the operation.
    > Then, I can only choose 2nd Table"s" format.
    >
    > N.B. I am using an application similar to MS Access, but it can access one
    > Database in the same moment only. Therefore, all Tables and Forms are

    always
    > stored in the same file.
    >
    >
     
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