Kbase P116534: Generation of table relations report is taking a very long time to complete
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
SYMPTOM(s):
Table relations report takes too much time to generate
Table relations report for one table takes up to several minutes
Using Data Administration
Data Administration seems to hang when generating table relations report
CAUSE:
The database schema is complex.
The table relations report generation algorithm has a complexity linked to the total number of indexes, fields, index-field relationships and tables. The complexity is not linear. A large number of these entities will cause the algorithm to take a very long time to process the report.
FIX:
Possible workarounds:
1. use a shared memory connection to the database instead of client-server networking.
2. reduce the number of tables, fields, indexes in the database prior to generating the report.
3. run the report generation on a faster computer.