Re: ISTAR/INET Performance Problem

Thomas Mclean writes: | Recently we upgraded a great number of our Informix database | servers with the latest available Informix 5.01 engines |(i.e ON-LINE, SE, STAR, INET etc) and products. |Version 4.10.UE1 to Version 5.01.UD2 on SCO UNIX |Version 4.10.UE1 to Version 5.01.UUD1 on CLIX (a brand of UNIX) | The problem simply stated is that Informix STAR and Net seems a |great deal SLOWER. This would probably be due to one of two issues - either the optimizer has changed, in which case you will need to check the 'set explain on output' for sequential searches, or there may be a bug in the version of STAR/INET - if you can, get a bug list for this version or perhaps a list of which bugs are fixed in version 5.02.xx - you may find one related to the problem you are experiencing. Hope this helps, Richard Ridley DHL Asia Pacific