Kbase P97578: Is it possible to allocate to many database buffers?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
26/11/2004 |
|
Status: Unverified
GOAL:
Is it possible to allocate to many database buffers
FIX:
Yes, and when you reach that point, one of two things is likely to happen:
You will get errors trying to connect or trying to start the server, because the number of buffers requested will exceed the available address space or other resource limitations.
You won't get errors, but performance will be severely degraded because the buffers are being paged.
Increasing the number of buffers improves performance because the amount of database I/O is reduced. Because you spend less time waiting for disk I/O, you can spend more time /using/ the data. That will increase the amount of cpu usage because you can spend less time doing nothing while data is being read from disk.