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

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.


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

WEBINAR:

On-Demand

Application Security Testing: An Integral Part of DevOps


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
×
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.
Thanks for your registration, follow us on our social networks to keep up-to-date