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
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.