Progress 9 Database Running Very Slow

I have a progress database that is running extremly slow on a UNIX box.  Is their a compact and repair feature for Progress?  How can I re-index the database.  And other ideas on how to speed the DB up.  It is taking 15 to 20 min. to return a query that used to take 2 min.  Any help would be great.

Thank you,
Ryan
Rcreese38Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
cwileConnect With a Mentor Commented:
I didn't see the bill last year, but I'm pretty sure it's only a few thousand dollars.. give or take :)

Here's a little better explanation about what they do:
http://www.bravepoint.com/consulting/dba.html
0
 
cwileCommented:
I have my progress 9.1d database "tuned" once a year by Dan Foreman.

I believe he is still contracted out of bravepoint down in Georgia.
If you've never had a progress tuning, I would highly recommend at least calling and asking his professional opinion on what to do.

-Corey
0
 
Rcreese38Author Commented:
What does it usually cost?
0
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

 
Rcreese38Author Commented:
Cwile,
Thank you for the info.  I will follow up with them.  Have you ever worked with Cedar Open Accounts by any chance?
0
 
cwileCommented:
No I haven't. I just got into the progress database stuff about 2 years ago and did some training down at bravepoint and that's how I learned about the tuning :)
0
 
Rcreese38Author Commented:
Thank you for the info.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.