on 04-28-2010 5:04 PM
Hi All,
how much data we can polled at one time from JBDC adapter?
Regards
Manish
Hi Manish
How much data can be polled by XI it all depends on your server configuration.
Idealy message should not be more then 5 mb.
you can poll more then 70000 records also but conditions apply - if it contains only one column, if having 50 columns then you cant fetch even 70000 also, so all depends on the msg size not on the number of records.
You can refer my blog to restrict the number of records to be fetched by XI, link is given by Shabarish above.
Regards
Dheeraj Kumar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
>
> Hi All,
>
>
> how much data we can polled at one time from JBDC adapter?
>
>
> Regards
> Manish
depends.
The maximum i have tried and was successful is 70000 records.
but in case you are looking to limit the extraction refer - /people/dheeraj.kumar5/blog/2010/04/12/pixi-sender-jdbc-select-query-and-update-query-to-limit-our-records-to-be-picked-up-by-xi-from-database-to-avoid-huge-message-processing-failed
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.