on 11-06-2008 12:51 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
> 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.