We help IT Professionals succeed at work.
Get Started

Performance problems with FoxPro 9.0 database

Comsyco
Comsyco asked
on
3,549 Views
Last Modified: 2012-05-12
Our client is using Pegasus Opera (which uses FoxPro 9.0) and is having some pretty serious performance issues. The software can take at least a minute to load the software and using the software can be painfully slow for them.
 
We have done some pretty drastic steps to try and help the situation but as of yet nothing seems to be making any difference.
 
We have upgraded the server to
2008 SBS x64
 Intel Xeon 2.27Ghz x 2
 8GB Ram
 Boot Drive - 467GB - Raid 1
 Data Drive - 931GB - Raid 1
 
The network was upgraded to run at 1000mb.

We have also looked into a known issue with SMB2 on 2008 servers and have followed MS tech notes to disable SMB2 in the registry.
 
My question is are there any known issues with FoxPro databases (or Opera if anyone has experience with that) or tips / tricks on improving performance for FoxPro databases in general that may be effective with our setup?
 
Thank you in advance for your help with this.
Comment
Watch Question
Software Developer
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 2 Answers and 9 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE