October 7, 1999 03:19 PM
(in response to Joel Goldstein)
Only problem could be if your processor doesn't have enough storage
support your buffer pools. If your buffer pools aren't seeing a lot
paging, then there isn't a penality. Otherwise, you may want to
better or get more real storage.
IBM uses a hash implementation to find pages in the buffer pool, so
used to find things in the buffer pool remains the same reguardless
size of the buffer pool (very nice). In fact, if the increase in
pool will avoid more I/O you'll probably see a reduction in CPU
because some CPU time is required to handle I/O.
> -----Original Message-----
> From: Ohling, Tim R - CNF [SMTP:[login to unmask email]
> Sent: Thursday, October 07, 1999 10:57 AM
> To: [login to unmask email]
> Subject: Bufferpool Allocation
> What are the potential issues with a bufferpool that is
> than it really needs to handle the objects assigned to it?
> The first one that comes to mind is that the space isn't
> other pools, but are there others that we need to be concerned