I am facing one XI performance issue. We are using PI 7.1 SP 7 on AIX 5.3 and Oracle 10.2.0.4
I have testing a simple file to file scenario, every 0.09 second, PI pull one 1kb size file from AIX file system and process, PI works fine, the item in Queue I see in SMQ2 is normally 10 - 20.
But someone has implemented their own Scenario, it ECC 6 send iDoc to PI, PI process and send to SQL Server 2000 by JDBC adapter, it also use Acknowledgment. They uses complicated mapping, normally takes up to 10 seconds. The performance is bad, items in Queue is about 1000+.
I really don't understand what is the problem.