How much data can be polled by JDBC adapter at one time

[Former Member]

Hi All,

how much data we can polled at one time from JBDC adapter?

Regards

Manish

[former_member185881]

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

[Shabarish_Nair]

>

> 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

[Former Member]

HI Shab,

I am having the doubt on how much data in size? we can poll by JDBC sender adater.

Regards

[Shabarish_Nair]

i am not really sure if that can be quantified since it would depend on the driver, server sizing etc.

The preferred method is to process in batches in case of high volumes.