We have a configured operation (ES 5.0) that is doing a basic notification on an AS/400 table. We are only able to process about 50 records a minute or so. The operation deletes the records after retrieving them. There are 87 fields on the table and the record length is 745 bytes.
Both the 400 and the unix (AIX) machine hosting the adapter are on the same network segment at 100mbs.
Is the JDBC adapters inherently slow? Is it the AS/400?