Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

How to do performance tuning ?

How to do performance tuning ?

How to do performance tuning ?

We are runnig a online transaction processing application on informix 4gl. The application has become very slow now after using it for about six month. Can you help me how we can improve the performance ?

RE: How to do performance tuning ?


Let's start with the basics;  Have you performed update statistics on the database?



RE: How to do performance tuning ?

Sorry to come back late.
No. I don’t know much about Informix. I referred the web and found some command like “onstat” for (Informix dynamic server) but these commands I can not find in our system. Is there a different between Informix 4GL and dynamic server?

Thank you in advance

RE: How to do performance tuning ?


Yes, there's a big difference.  Informix Dynamic Servier, IDS, is the database while, Informix 4GL is the application language that speaks to the database.  onstat is an informix utility for monitoring the database.

The UPDATE STATISTICS command recalculates the data in the system tables, and, generally, speeds up queries.  It's common to run UPDATE STATISTICS, US, daily, especially, if you have a database with a lot of transactions.

US is valid 4GL syntax, so a program like this works:


update statistics

end main

However, most of the time, US is executed manually using the query language from Informix's dbaccess or isql utilities.  For automatiing this process, check out the software archive for the Internation Informix User's group, www.iiug.org.

I recommend reading the Update Statistics docs.  If your database is very large, running US with no options may take a long time.  For example, you can run it against single tables in the database and even single columns.



RE: How to do performance tuning ?

Hi Ed,

Do we need to have IDS and 4GL if we want to run the 4GL application?
The onstat command in not in the server. Is that mean the IDS is not installed ?

Many thnks.

RE: How to do performance tuning ?


Your 4GL application is communicating with a database.  It doesn't have to be IDS;  It could be version 5 or even standard engine, SE.

You can't find onstat.  If it's version 5, all the database utilities start with "tb".

Also, is your 4GL application on the same server as the database?  It doesn't have to be.  In that case, you won't find any of the database related commands on the 4GL server.

Is shell variable INFORMIXSERVER set?  If you are running IDS, it'll be set to the unix server where your database resides.

change to $INFORMIXDIR/bin directory.  What commands do you see here?



Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close