JDBC sender adapter Q - db.disconnect - option

[Former Member]

I have a question in JDBC sender Adapter configuration.

The value for db.disconnect = NO|YES,

The database connection is released and then reestablished before each poll interval.

The default value is NO.

Which value is preferred, taking the performance into consideration? Can anyone please explain...

reg

[VijayKonam · Accepted solution]

If your polling interval is longer, use disconnect = true. If you are polling from almost near to real time and any where till 5 sec, do not disconnect. This would add lot of load on the DB in the second case.

VJ

[prateek]

Which value is preferred, taking the performance into consideration?

Connection increases load on the system. Thats why it is always preferred to disconnect after the completion of operation. But logically, if the polling interval is so small that the disconnect and reconnection will take an equivalent time, then it is better to let the earlier connection open.

In general terms, performance wise, disconnect and reconnect is a better option.

Regards,

Prateek