Your Informix Database has been slowed down during the past months? Response times have increased? Users have to wait?
Because of this you are going to purchase more powerful computers? Or another Informix Edition/Version? Stop! Most likely you only need to optimize your Informix database! And tuning Informix is cheaper and faster than buying new Hard- /Software!
In the following some general recommendations:
- Use indices
- Avoid Sequential Scans
- Think about Hyper Threads or SMT Threads
- Extend your bufferpool
- Check the SHMVIRT segment
- Take care of enough Locks
- Configure Temp Dbspaces
- Optimize Disk IO (LRU, KAIO, Direct IO)
- Use CPUVPs
- Don’t forget Updata Statistics
Despite of these tips: you have to test, test, test … - and this takes some time – because too different are datatypes and structures, data volumes and requests.
If you do not like to analyze, optimize and test on your own, contact hamburg data. We have been working for more than 20 years with Informix. We overtake the job, check the status quo, coordinate the planed status together with you and trim your Informix database for the future – structured, quick and worth the money.