Re: 7.20 performance.

erik@rat.se (Erik Heimdahl) wrote: :I have recently upgraded to 7.20.UC2 from 5.07.UC1 on my SPARC 20 (single processor) running :SOLARIS 2.5.1, and the first performance-tests I made is really bothering me. :When doing very simple tasks as pure INSERTS, UPDATES and SELECTS from indexed tables i get a :better performance from my 5.07 than from the 7.20. :In some SPL run through DBACCESS i get about 30% better juice from 5.07. :Doing the same operations in ESQL/C takes about twice the amount of time in 5.07, which is :acceptable concerning the flow of data between the sqlturbo-process and the ESQL/C program. :The same operations using ESQL/C-7.20 takes about six(6) times longer than using SPL-7.20, which :still is slower than 5.07. :All in all, ESQL/C seems to be more than twice as fast on 5.07 than on 7.20, and pure raw :performance about 30 % better. :The OS is configured according to the parameters in /usr/informix/release and when using onperf :and dbcockpit, I can't see anything else than what You might expect. :Has anyone experienced something like it ?? :Is this a known problem, or have I not been able to configure 7.20 correctly (there are not that :many parameters to fiddle with on a simple application like this) ?? It's a known problem. However the general consensus from a lot of previous discussion on this issue is that you can usually achieve a similar performance on version 7.x OnLine to what you had on ver. 5.x The discussions have however allways related to 7.1x and not 7.2. May be 7.2 is slower on a machine like yours. To achieve this performance you do however mostly have to do extensive tuning. You might want to search the archives of this group at http://www.iiug.org or on http://www.dejanews.com for more info. For more information you may also check out the good whitepaper at http://www.informix.com/informix/services/ilink/alerts/upgrade.htm assuming you have access to the Informix Tech Info Center. It also contains examples of cases where 5.x gives better performance than 7.x. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org