Re: Q for Informix Gurus : Informix/ESQL-C performance

First things first. Have you run UPDATE STATISTICS on your machine ? If data is in GBs , then just update statistics for all databases may take days. moreover, UPDATE STATISTICS can be run for entire database or a particular table or for a particular column of the table . So take advantage of this feature of informix. Next, check whether co-related queries are running within the application. Co-related queries are costly. Also give info on whether it is OLTP application / Query intensive application. This information will be very helpful. Harinath venkata RVASUDEV <RVASUDEV@inf.com> wrote in article <72pa9h$9is$1@news.xmission.com>... > > Hi Gurus, > > Where can I get info about how to performance tune > an Informix/ESQL-C program? I have a complex program which > talks to several other processes & databases. It seems to > be running slower than expected. I'm in the process of collecting > all relevant information about this - so for now I'm just asking a > general question without providing specific details. I'll post > more info shortly about the actual programs involved. > I'm fairly new to Informix too, so no flames please ! > (And yes, I'm in the process of reading all the manuals I > can lay my hands on ;) > > I'm looking at things like use of indexes, the optimizer, > SET EXPLAIN PLAN, etc.> > Configuration : > > HP 9000 > HP-UX Ver 10.10 > Informix Ver 5.0 > Informix 4GL Ver 4.1 > C compiler & runtime library (HP-UX) > TCP/IP on HP-UX > Informix Star > > > Thanks in advance > > Vasudev Ram > Infosys > > > > >