If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Should I break down this kind of Table? .
My original table 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 Now, should I break this table into 5 (One index with one translation only) ? Which Table Format consume less memory? Which Table Format run faster? 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
|
|||
|
|||
Should I break down this kind of Table? .
There are some folks that probably can give better advice than I but it seems
that you need a table structure like this -- Book_Index Language Translation Integer Text Memo With the Language specified such as English, Greek, Latin, etc. Or use a number, long integer field related to a reference table of Languages. Then you would append from the existing table to the new one. "Cicada" wrote: My original table 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 Now, should I break this table into 5 (One index with one translation only) ? Which Table Format consume less memory? Which Table Format run faster? 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. |
#3
|
|||
|
|||
Should I break down this kind of Table? .
Thanks for your reply.
I will have another table to register th language for different column / table. But my below main point is: Which table format is more optimized? For 1st Table, it is good for later mulit-version 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. "KARL DEWEY" ... There are some folks that probably can give better advice than I but it seems that you need a table structure like this -- Book_Index Language Translation Integer Text Memo With the Language specified such as English, Greek, Latin, etc. Or use a number, long integer field related to a reference table of Languages. Then you would append from the existing table to the new one. "Cicada" wrote: My original table 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 Now, should I break this table into 5 (One index with one translation only) ? Which Table Format consume less memory? Which Table Format run faster? 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Choosing a package, return all items | Teri | New Users | 10 | June 7th, 2006 03:34 PM |
Displaying File properties on a Access 2000 Form | Chris Fillar | General Discussion | 2 | March 16th, 2006 02:22 PM |
Need to Improve Code Copying/Pasting Between Workbooks | David | General Discussion | 1 | January 6th, 2006 03:56 AM |
Access combo box-show name, not ID, in table? | write on | New Users | 30 | April 30th, 2005 09:11 PM |
Table Design | A. Williams | Database Design | 3 | April 29th, 2005 07:02 PM |