Oninit cdi / Archive
Talk to an expert →

Performance Problems with SE 7.10 and Unixware 2.01

Posted in 1996

Topics: Performance & Tuning, Stored Procedures & SPL, Connectivity: ESQL/C, 4GL & Embedded SQL, Triggers, Constraints & Referential Integrity, Networking & sqlhosts Configuration, Migration, Import/Export & Data Conversion

Pierluigi — — source: Informix-list mailing list archive (1991-1998)

2 days ago i translated the administrative database from Se 5.01 + 4GL RDS 4.11 to SE 7.10 + RDS 6.04. After a DBEXPORT vith 5.01 and a DBIMPORT with 7.01 i recompiled programs, remake Stored Procedure and Triggers and start a "update statistics". With the reports i have no problems, but with the programs now i need 1 minute for insert a row of "Customers Orders" and with 5.01 only 2 seconds!!!!! It's impossible to work !!!! - A specific problem of the Unixware 2.01 version? - Kernel parameters to tuning ? - Problem of the TCP/IP Configuration and of the sqlhosts file ? - The logic of the optimizer is changed and so i have to redesign the index structure ? If somebody can help me ....Thank You ! Ciao Pierluigi Paccagnella (medico@protec.it) ======================================================================= Pierluigi Paccagnella MEDICO Spa - Padova - ITALY medico@protec.it =======================================================================

Glossary