ORACLE vs. Informix Performance: What Is Fastest?

} Help!! I'm an ORACLE person, not an Informix person, and unfortunately my } client is running an Informix RDBMS with Intergraph FRAMME front-end. } They are experiencing very slow performance, requiring about 1.5 hours to } extract a work set (about 1000 components). The first access is the } fastest, performance decreases with each extract. Here's what they are } running: } } [...details, .redundant .sig, and header to another post deleted...] } } My client is running Informix 5.0 on an Intergraph 6850 box under CLIX } 7.5; unfortunately, they are experiencing unacceptable performance. } Intergraph says they are running the same rulebase in Huntsville using } ORACLE 7, and not experiencing any performance problems. Does this sound } legitimate? We are talking about 1.5 hours in Informix vs. several } minutes in ORACLE. } } Dagmar Anne Bogan } } } Kopania & Komerovsky Specializing in Data Architecture } Richardson, TX 75081 and Performance Engineering } } dagmara@delphi.com Sure, you don't have all the indexes set up in the informix installation. That would easily cause your problem. Other things that would cause this symptom are: I/O bottlenecks. You said the network is not overworked, but how about the disk controller and the disk itself? Updated Statistics. Have you run this since the db was populated? CPU bottlenecks. This is pretty rare for a db, but it's possible that Intergraph is doing some math or mapping or something that's eating the CPU. I would be very surprised to find that it's an Obstacle--uh, Oracle vs. Informix problem unless the machines were vastly different. Check your indexes, first. __________________________________________________________________ | Clem Akins Standard Disclaimers Apply | |Reynolds Metals Co, Alloys Plant "Climb High, Cave Deep!" | | Muscle Shoals, Alabama USA cwakins@leia.alloys.rmc.com | |________________________________________________________________|