Performance Questions 7.x

HELP! How long can it take?! A simple query in our database is taking a L-O-N-G time to execute. It's not our application, because we experience the same problem from isql. We've fragmented our tables, set read ahead parameters, and added a couple of page cleaners. It is definitely having a problem with the size of the database (which is indexed, maybe not properly ;-). We have several dbspaces that our broken out by our fragmentation scheme and one big blobspace: address chk/dbs offset size free bpages flags 80737d20 15 15 511040 500000 ~202580 250000 POB /dev/informix-1 Is this the problem? Is informix just a big slow pig? Sorry for the name-calling, but I have exactly 2 weeks to have this system screaming, and it's not. You're help is greatly appreciated! BTW, when I mean slow, I'm talking 15-30 seconds to execute an sql statement and return the data. I have a requirement of 3-10 seconds. What's left? We are running INFORMIX-OnLine Version 7.10.UD1 on an HP-UX A.09.05 A 9000/755. I'm out of ideas, can someone email or post their thoughts on how to improve performance of our database. -- Carol L. Stimmel, Systems Analyst NOAA/ERL/FSL work: stimmel@fsl.noaa.gov 325 Broadway home: stimmel@majordomos.com Boulder, CO 80303