We configured Proxy to PI to JDBC, interface is working fine when getiing around 10,000 records. We are facing problems when there are 40000 to 50000 records. Cant PI handle these many records.
PI is going very slow and and nearly taking 2-3 hrs for processing records to target system.
What was the reason and please let me know how to achieve this process.