RE: Degraded performance of Replication

Posted in 2004

Link, David A. — Wed, 21 Jan 2004 13:55:26 -0600 — source: Usenet: comp.databases.informix

Just saw that I posted via HTML. Sorry........ -----Original Message----- From: Link, David A. Sent: Wednesday, January 21, 2004 7:48 AM To: Informix-List (informix-list@iiug.org) Subject: Degraded performance of Replication We have a replicated table on 2 IBM P680's running AIX 4.3.3 and Informix 9.30.UC2. In our tests we have pushed through as many as 1600 tx/sec, which is great. We are planning on upgrading to AIX 5.2 and Informix 9.40UF3. We are only able to get 1300 tx/sec on the same class of servers. I would have thought that with the OLTP improvements in 9.40 that we would have gotten better performance. ' The only thing we have changed is that we narrowed the table. We are going to retest with the original table but I thought I would see if anyone would have have any suggestions? Just looking at the incoming OLTP transactions the newer version seems to run much better. I am just wondering what we could be missing. ' Thanks for any suggestions in advance. ' David Link ' sending to informix-list