At 03:51 PM 10/3/2002 +1200, Tom Munro Glass wrote:

>Can someone please explain the difference between the number of buffers
>specified with these two commands, and are there any guide lines for how to
>set these up for maximum performance?

isc_dpb_num_buffers sets the number of buffers to be used
for the current connection. It makes most sense in a classic
architecture, where each connection has its own buffer pool.
In superserver, it will set the number of buffers to be used
for the specific database, if that database is not already
open, but will not persist after the server closes the database.

isc_dpb_set_page_buffers is useful in both classic and
superserver. It sets a default number of page buffers to
be used with the database whenever it is opened.

As for guidelines, well, no, not really since it depends heavily
on the type of access. An application that is insert intensive
needs fewer buffers than one that does a lot of indexed retrieval.
When the server handles many clients for the same database, using
different tables or different parts of table, then it needs more
buffers....


Regards,

Ann
www.ibphoenix.com
We have answers.