Re: Informix SE 7 slower than 5 ?

Looks to me that in terms of user and system time SE7 was close to 250 times faster than SE5 but these times are likely for the front-end (dbaccess??) and do not include the actual timings for the sqlexec processes. This is one of the difficulties with timing client/server applications on a timesharing OS like UNIX. The only difference is in elapsed time which may well be simply because the process was asleep waiting for the sqlexec process to finish and there were other processes ahead of it in the ready queue. Place the test into an ESQL/C program and use gettimeofday to time the actual SQL. Also run the test 100 times each alternating between the two versions to eliminate OS overhead biases. Do you have SE5 & SE7 looking at the same datafiles on the same disk drives? At least are the files on the same filesystems? Art S. Kagel Evelio Martínez wrote: > How can be Informix SE 7 slower than SE 5 under the same system and > circumstances ? > > the following sentence takes 3 minutes, 51 seconds to search under > 563274 rows > > select sum(can) from dma where tma="V" ; > > INFORMIX 7 > 2385363,99000000 > real 3m53.07s > user 0m0.04s > sys 0m0.02s > > INFORMIX 5 : > (sum) > 2385363.99000000 > real 2m32.43s > user 0m10.07s > sys 0m4.36s > > -- > Evelio Martínez > Af Informática Aplicada,S.A. > C/Eduardo Bosca, 13 > 46023 Valencia (España) > Tel: +34 96 337-95-80 > Fax: +34 96 337-81-18