SE 7.24 performance
Posted in 2000
r_hao — — source: Informix-list mailing list archive (1991-1998)
Hi, experts; We have a table with about 14 million records. This table was part of database running on Linux machine(SE 7.2 too). Since you got a better HP UNIX (10.2) machine, we moved it to HP UNIX. However, the performance of SELECT sql (we only do the 'select' in day-time and 'insert' in night-time) against that table is worse then when it was on the Linux. I have updated STATISTICS, and created many index and alter major index to CLUSTER index, the performance seem to be the same. What others I can do for it. Thank for your help in advance Randy