Re: Need help with Informix performance

Posted in 2005

Claus Samuelsen — Thu, 10 Mar 2005 15:01:04 +0100 — source: Usenet: comp.databases.informix

Unholy wrote: > 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. > run: $ echo "update statistics" | dbaccess database_name