×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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!
  • Students Click Here

*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

Performance issues..please help

Performance issues..please help

Performance issues..please help

(OP)
hi..

psql 9.5 with sp2.

struggling bad with performance..

i check the performance monitor often to see that the:

pages per sec averages at around 300
average disk queue averages from 3 - 6

i asked the application guys and they had me change a few settings in the pervasive control center...but that didn't do much at all..

all of the users are going crazy..

dual xeon 3.0Ghz with 2GB of RAM..the CPU and RAM are fine performance wise (seems to be so anyway).

any suggestions would be greatly appreciated. thanks
Edit/Delete Message

RE: Performance issues..please help

As stated on another forum, you need to provide a lot more information.  
Specifically, you need to tell us what the application is actually doing.
From one of my posts on the other site:

Quote:

As far as the rest of it.  HOw does the application work?  Does it use the Btrieve interface or the SQL interface?  What if you simulate some of the operations outside of the application?  Is it slow?

Have you talked with the vendor of the application?  WHat do they say other than changing a few settings?  

I know that Btrieve/SQL is more than capable of handling 50 concurrent users.  I know of sites that have over 1000 concurrent users with no problems.  

You need to find out what's actually slow.  Is it the Btrieve/SQL portion, the network, the disk access, the application, or something else.  

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

RE: Performance issues..please help

(OP)
thanks for that,..

i'm also curious about the server.. but i'm still sceptical that an upgrade to an e.g 2 x dual core server might not even make it much better..

what are your thoughts? thanks

RE: Performance issues..please help

Usually upgrading the CPU doesn't help.  THe PSQL engine is usually I/O bound not CPU bound.  

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

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