Performance problems with Online 5.03.UC1
Posted in 1995
Hello Informixers! I have Informix-Online 5.05.UC1 running on UNISYS/SVR4, recently I have been several performance problems. I have a table with 85,000 rows aprox. and all the indexes look right for me. I already run UPDATE STATISTICS, tbcheck -ci, tbcheck -cI. I'll recreate all the indexes for that table, but if you have any idea how improve the performance, please let me know. If you need to check something else, like: configuration, tbstat output, set explain output.... I could send you later! thanx in advance! ////// +------------------------------ooo-O-O-ooo--------------------------------+ | U | | Melvin Perez Cedano Santo Domingo, Dom. Rep.| | Vice-President m.mejia@codetel.net.do | | Systems Development Phone (809) 686-5574 | | CAM Informatica, S. A. Fax (809) 686-5467 | +-------------------------------------------------------------------------+