Kbase P83707: Is it beneficial to consider the mean record size of a table when performing a V9 binary load?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
GOAL:
Is it beneficial to consider the mean record size of a table when performing a V9 binary load?
GOAL:
Do I need to consider the average record size of a table when performing a V9 binary load?
FACT(s) (Environment):
UNIX
Windows
Progress 9.x
FIX:
Yes. The mean (average) record size for any table must be considered when optimizing any database table for sequential access. The recommended method is loading tables with records of less than 1000 bytes first (in the order of their average record size, lowest to highest). Then, load the remaining (larger tables) in the order of their mean (average) record size (lowest to highest).