How to improve performance of JDBC adapter used in Communication Channel

[Former Member]

Hi All,

I am using JDBC adapter in a communication channel and it contains multiple receiver services, while executing jdbc statement taking more and more time. please guide me where the problem is..?

Thanks in Advance.

Regards

Nagesh.

[Former Member]

mailny it is based on your database structure and no. tables involved in your query, so optimise it first

[Former Member]

hello,

Stored procedure is a good option for improving some performance of JDC adapter used in Cc..

But do check this link .. might be of some help to you .

Regards'

Vijay

[Former Member]

You can call Stored Procedure using XI.

A query takes more time to execute than Stored Proc because it is compiled then executed while later is already compiled. You can also refer this:

http://help.sap.com/saphelp_erp2005vp/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Regards

[VijayKonam]

What do you mean by multiple receiver services? Could not get the problem..

VJ