Re: Performance Problems (7.12)

keiths@prestongates.com wrote: >Is anyone using Informix 7.12 on an HP 9000/G70 system? >If so are you or have you experience performance problems? >I would like to discuss or see how you have your onconfig file setup. >We are running Elite's Accounting package for lawyers and since we converted from 5.x it runs slower at times then it did before. >Mail response to keiths@prestongates.com >Tks >Keith We do have informix 7.12 running on hp9000 h70 systems. So far we have not had any performance problems. I do know if you are using informix 4gl,esqlc,or isql and did not upgrade those the relay module is reported to be a dog. You may also check on the update statistics offered with 7.1. I would run the set explain on the queries that take longer now. If you fragmented after the upgrade if you did not fragment correctly or you fragmented a small table. The fragmentation overhead may be costing performance. Sometimes if the table is not very big the bybacks from fragmentation is not enough to offset the overhead. The appl we have running on 7.12 is newly developed. -- Tolly Brumbelow, Informix DBA email:tolly.brumbelow@bridge.bellsouth.com