Seems OK-ish ;)
At 11:34 AM 12-10-99 -0400, [EMAIL PROTECTED] wrote:
>Hello,
>
>I want to increase the number of connections per database that I have
>configured in my RDBMS Service for ND4.1.3. Currently, I have the following
>configurations:
>Service Properties: number of workers = 10
>Worker Properties: maximum database connections per process = 10
> maximum db connections per DB = 100
> number of worker processes = 10
> maximum # clients per worker = 10
>
>I want to increase the number of connections per database to 20. When I do
>this, are the following configurations correct keeping 100 max db connections?
>Service Properties: number of workers = 5
>Worker Properties: maximum database connections per process = 20
> maximum db connections per DB = 100
> number of worker processes = 5
> maximum # clients per worker = 5
I think you'll want to set the clients/worker to 20 instead, assuming you
want to have the same #concurrent DB requests to be available and assuming
you're running w/ 2 DBs. In which case you probably want to set the #DB
connections/process to 40.
>Also, when I increase the number of db connections per process, does that
>increase the load on the CPU or memory of my application server?
idle DB connections just take up a lot of memory, not CPU-cycles , apart
from the occasional keep-alive stuff for the network connection. Memory is
cheap(ish), so just get lots of it.
>Thank you in advance. Your advice is appreciated.
>Sal
No problem.
Cheers,
Edwin.
>_________________________________________________________________________
>
>For help in using, subscribing, and unsubscribing to the discussion
>forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
>
>For dire need help, email: [EMAIL PROTECTED]
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
