cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC adapter performnce in PI

Former Member
0 Kudos

Hi,

Regarding JDBC adapter in PI 7.0 and performance I have below 2 queries:

1. What are the different ways in which we can measure the performance of various components (IS, AE etc) in a JDBC scenario.

2. How to determine what is the optimum number of JDBC calls that can be made in a specific time period without affecting PI performance.

Appreciate your response on these queries

Thanks,

Girish

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Girish,

JDBC performance in XI relies on multiple factors :

- performance of the database itself (tuning, params, etc).

- performance of the queries you're using (where clause using existing indicies or not etc)

- performance of the mapping you're using to generate the message

- performance of the XI subsystem (threads, etc)

afaik, there is no "generic" way to test or foresee all of the above, so benchmarks, tests and collaborative work with DBAs is required

Rgds

Chris

Former Member
0 Kudos

Hi

1. What are the different ways in which we can measure the performance of various components (IS, AE etc) in a JDBC scenario.

It depends on various parameters for instance the kind of mapping involved (if it is xslt mapping time taken would be more than a graphical mapping), database you are trying to connect. In general there is a document on SDN that talks about the XI performance and tuning.

2. How to determine what is the optimum number of JDBC calls that can be made in a specific time period without affecting PI performance.

This would depend again on the database being used. Also various parameters in XI like "Disconnect from the DB after each message process".

Regards

Monika

Former Member
0 Kudos

Thanks all for your response,

For point 2 any suggestion on how I can test this scenario.

Regards,

Girish

Former Member
0 Kudos

Hi Girish

2. How to determine what is the optimum number of JDBC calls that can be made in a specific time period without affecting PI performance.

This depends on the hardware of your system where database resides. With this number of connections can also be managed by administrator. While installation you set DB connection pool.

You can do a performance test by running JDBC queries to the table from multiple channels this will provide the report. Also use End to End monitoring to get some static values on performance for this

Thanks

Gaurav

VijayKonam
Active Contributor
0 Kudos

> 1. What are the different ways in which we can measure the performance of various components (IS, AE etc) in a JDBC scenario.

You might have to look at end to end component monitoring for this..!!

> 2. How to determine what is the optimum number of JDBC calls that can be made in a specific time period without affecting PI performance.

As far as I know, this must be determined on a trial and error basis. It depends on whether you opening a separate database connection for every transaction or using the same one for every call. Depends on you database machine capabilty and XI hardware also.

VJ