RE: Need help with Informix performance

Posted in 2005

Savio Pinto (s) — Thu, 10 Mar 2005 09:19:55 -0600 — source: Usenet: comp.databases.informix

here are few things that you would need to do 1. update statistics for the database 2. you may need to modify the queries in order for them to run fast, you will need to capture the query plans and change the queries that are performing poorly. after doing this, i am pretty sure your application will run faster (and, maybe 3 to 4 times faster than what it takes in sqlserver) -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]On Behalf Of Unholy Sent: Thursday, March 10, 2005 6:10 AM To: informix-list@iiug.org Subject: Need help with Informix performance I have an application that runs really fast in Sql Server. The same one, but in Informix is really slow. I hace imported the database from Sql to Informix, (tables, views, indexes and keys), and everything works fine, and also set the lock mode to row, but the informix system is at least 3 or 4 times slower than Sql Server one. Somebody can help me about how can I increase speed of the system??? The database is a Informix 9.3 in a HP-UX server. sending to informix-list