Kbase P11838: Is there a performance problem with setting up different records per area base on the size of record
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/7/2009 |
|
Status: Verified
GOAL:
Is there a performance problem with setting up different records per area base on the size of records?
FACT(s) (Environment):
Solaris SPARC 2.6
Progress 9.1C
FIX:
No, this is one of the benefits.
Follow our documentation found at www.progress.com.
Generally place the table(s) with smaller records in an area with a higher number of records per block.
This will be relative to the blocksize and the actual record sizes.
Refer to our documentation for more information on setting up different areas and the implications.
Request a consultant, if you require assistance on the tuning of your database.