Guidance request

Posted in 2017

Topics: Performance & Tuning, Platform-Specific Issues

JOHN HENRY — Thu, 06 Apr 2017 19:33:34 — source: IIUG Forums & Mailing Lists

Hi All, I'm not sure of what area to post this question so I am starting here. We are trying to solve a performance issue. The current situation is as follows. We are upgrading hardware on for the Solaris/Informix server components. we are seeing 2x to 4x improvements in all database testing of procedure and sql execution. However when using an application built on PowerBuilder we do not see any improvement and we see some degradation. There is a thought that there may be some network setting, packet size things to look at. Also there may be some client side things to look at. we use setnet32 so I am wondering if anyone out there can share their experience with any of these issues that could be resolved by changing settings. Please let me know what other information I can pass on in hopes of getting so help.

↪ replying to JOHN HENRY

Andrew Ford — Thu, 06 Apr 2017 21:22:39 — source: IIUG Forums & Mailing Lists

You've migrated your engine to new hardware, but the client equipment has not changed, right? What version is the Informix engine and did you run update statistics after the migration (if you did a migration)? Andrew -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of JOHN HENRY Sent: Thursday, April 06, 2017 2:34 PM To: ids@iiug.org Subject: Guidance request [38860] Hi All, I'm not sure of what area to post this question so I am starting here. We are trying to solve a performance issue. The current situation is as follows. We are upgrading hardware on for the Solaris/Informix server components. we are seeing 2x to 4x improvements in all database testing of procedure and sql execution. However when using an application built on PowerBuilder we do not see any improvement and we see some degradation. There is a thought that there may be some network setting, packet size things to look at. Also there may be some client side things to look at. we use setnet32 so I am wondering if anyone out there can share their experience with any of these issues that could be resolved by changing settings. Please let me know what other information I can pass on in hopes of getting so help. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.