High volume of records :jdbc stored procedure

[Former Member]

Have a receiver stored procedure which populates a table and sender sync proxy scenario. While pulling records from database , is there any limit on how many records can jdbc adapter via stored procedure pull from a table, i would be having about 1000 records to be pulled from a table .

if anybody has any idea about volumes do suggest.

Thanks

[former_member208856]

PI can handdle 1000 records easily. But it also depends on structure of table & data for how many fields you are pulling.

First check your scenario, i hope there will not be any issue.

[former_member568822]

Hi,

PI can handle large amount of data but its depend on you server hardware performance. I try pulling 10k using stored procedure and its working fine.