maxActive/ maxIdle - DB connection

Post here your questions about Actionscript and Java server side extensions development.

Moderators: Lapo, Bax

robejms
Posts: 20
Joined: 25 Sep 2009, 09:10

maxActive/ maxIdle - DB connection

Postby robejms » 28 Oct 2010, 08:19

Anyone know what the following do in the config.xml when setting up a connection to a DB?

maxActive
maxIdle
OnExhaustedPool
BlockTime

Many thanks
Rob
TiagoR
Posts: 83
Joined: 15 Mar 2010, 11:42
Location: Portugal
Contact:

Postby TiagoR » 28 Oct 2010, 08:45

What about reading the documentation...

If you go to http://www.smartfoxserver.com/docs/ under 3. Connecting to databases you got:

The following table illustrates the meaning of the those tags:

MaxActive: The max. number of pooled connections

MaxIdle: The max. number of idle pooled connections (-1 = no limits)

OnExhaustedPool: Specifies what action should be taken when the pool of connections is exhausted:
fail >> returns an error (RECCOMENDED)
grow >> grow the pool (Attention! You may need extra heap memory in your JVM or you could crash it)
block >> block for some time before returning an error

BlockTime: used only if you choose to block when the pool is exhausted. Expressed in ms.
TR

Return to “Server Side Extension Development”

Who is online

Users browsing this forum: No registered users and 13 guests