Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Informix
Expertise: Beginner
Feb 2, 2000

Database Performance Degradation

Question:
We are running Informix On-Line Database Engine 7.23 on an HP UX 11.0 machine with 4 CPUs. The database is connected through a middle-tier, which is ENTERA Application Server running on a different machine.

We are experiencing performance degradation when the number of users is above 700. Can you give me any hints about what could be the problem?

Answer:
There are literally thousands of things that could be causing your problems, and your question doesn't really allow me any way to narrow down the possibilities. What kind of performance problems? Slow queries? Connection times? Database lockups? Type of applications (OLTP or DSS)?

A quick suggestion. Your 7.23 Informix is a relatively old version. These early versions seemed to have multiple performance issues, especially in the HP environment. You might look into upgrading to the latest 7.3X version of Informix. Otherwise, if you'll post me some more specific issues, I'll try to help.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date