on 10-05-2015 12:19 PM
Hi Experts,
am using 7.4 single stack with JDBC adapter, need to advise Dlx(data base) to set the optimal number
records for our PI processing .can any one please tell me for this question.
Thanks
Narendra
Hi Narendran,
The only way to know it is to work together with the DB team. You can prepare a SOAP - JDBC scenario for testing purposes and to prepare a set of request with (1 - 10 - 100 - 1000 and so on).
You make the requests and the DB team make a monitoring of the DB resources. Later with your requests and their monitoring you can figure out what is the best approach.
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Just adding to the other comments here, there are some factors that need to be considered before you can work out the ideal result set size. I'm assuming that because you need the DB team to configure the result set size that you're using stored procedures and not a query configured in the channel? Either way, the science is not exact and I generally employ a process like below:
Hope this helps.
Hi Sritharan
yes,it is database side.
Thanks
Narendra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Narendran,
It depends on how much data you wish to update and store.And also on the RAM size like how many queries can be handled.
You can refer the below link which similar to your query.
Hello Narendram
Where you would like to set the optimal size ,Is it In database?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
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.