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

proformance problem executing stored procedure (2)

proformance problem executing stored procedure (2)

proformance problem executing stored procedure (2)

I have a similar problem, but mine is not java related. I have optimized my store procedure and it works real fine. However when I run 10 in the background it eats all my CPU time. I have tried run 25 select statements on the same table and it does not eat up so much CPU.
Even so, is Informix suppose to take up all the CPU time when it can? It seems strange that one store procedure can use up the whole CPU (four stored procedures running together and the other 6 waiting to be executed in the queue).

I am using IDS 7.31 on Solaris 4CPU.
The stored procedure creates and populates a few temp tables, then creates indexes.
Performs some updates and returns the result set in another table.

OK so the SP is not nice but is there a way to limit the usage of each process??

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