Showing results for 
Search instead for 
Did you mean: 

High volume of records :jdbc stored procedure

Former Member
0 Kudos

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.


Accepted Solutions (0)

Answers (2)

Answers (2)

Active Contributor
0 Kudos

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.

Active Participant
0 Kudos


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.