Kbase P15206: How are performance and resources affected by storing data in temp tables?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/04/2008 |
|
Status: Verified
GOAL:
How are performance and resources affected by storing data in temp tables?
FACT(s) (Environment):
All Supported Operating Systems
Progress 8.x
Progress 9.x
OpenEdge 10.x
FIX:
With temp tables the client has to do all the updates and there are additional overheads for the work normally undertaken by, for example, the asynchronous page writer.
One advantage of having temp tables (on a separate disk) is that contention for records is virtually eliminated as what you have is basically a very private single user database.
If the temp tables were very small the -Bt parameter could be set to hold all of them which would be a performance plus.
The fact remains that 2 Database Administrators could give entirely different but equally justifiable answers due to the variety of factors involved.