[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


What raid configuration is best for a FoxPro database?

Posted on 2011-10-27
Medium Priority
Last Modified: 2013-11-14
My ERP program is written in Foxpro and it dawned on me that the RAID configuration may affect performance of the database. Are there any special considerations when hosting a Foxpro database on a server?

Approximately 100 users
Database size 4.2 GB
Question by:timamartin
  • 2
LVL 30

Accepted Solution

Olaf Doschke earned 2000 total points
ID: 37038113
I'd say LAN will be the limiting factor mostly with that much users and the LAN throughput per user can't be optimised with better hdd performance on the file server side. What bandwidth do you have there? 100Mbit and even 1GBit means a single hdd is faster than the LAN anyway. Besides the file server system cache helps much better than a fast raid, as it's in RAM.

With a size of 4.2 GB, file caching of the server OS may even keep most of the database in RAM memory. While Foxpro itself is 32bit, a 64bit file server can adress more than 4GB RAM to cache all your database files.

You should be aware of the oplock problem, though, which is the default for the modern server OSes. While it's meant for better performance, it does so by putting caching to clients, as long as only one client accesses a file. That is not a typical scenario for database access and means a penalty, once a second user accesses the same table being cached at some other client. It's recommended to avoid it: http://www.dataaccess.com/whitepapers/opportunlockingreadcaching.html#Data_Access_Worldwide_Recommendations

Bye, Olaf.

Author Comment

ID: 37038196
Most are 1GBit there may be a few stragglers still but not more than 2 or 3.
LVL 30

Assisted Solution

by:Olaf Doschke
Olaf Doschke earned 2000 total points
ID: 37041147
In regard of hdd bus architectures:
Desktop/Server: SATA is at 1.5, 3.0 and even 6.0 Gbit/s busses.
Server: SAS bus bandwith goes up to 12 GBit/s via dual channel.

You don't need SSD to get higher than the reference 1Gbit/s LAN speed, even with a single hdd drive. 1Gbit/s is a transfer rate of 125 MB/s, which can be achieved by SAS drives.

If you need faster, check out - http://www.fastestssd.com/featured/ssd-rankings-the-fastest-solid-state-drives/#pcie

Thus RAID would just be interesting performancewise, if you do local data processing, for any LAN client, the 1 Gbit/s bandwidth is the limiting bottleneck.

You can of course higher the availability and reliabilty with RAID, especially with hot swappable drives. I'd still recommend RAID 10 in that respect or RAID 1 for just the reliability.

Bye, Olaf.
LVL 43

Expert Comment

ID: 37043855
I have to agree RAID 10 is fast and reliable (and the most expensive variant). RAID 5 is reliable but slow on writes. RAID 0 is fast but not reliable at all.

An important information is the application architecture and topology. How do you access your app and data?

You may use the server just as a file server, you may use terminal services, you may create a COM object for each user on the server etc.

Also temporary files location can affect the application speed.

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to update Firmware and Bios in Dell Equalogic PS6000 Arrays and Hard Disks firmware update.
How much do you know about the future of data centers? If you're like 50% of organizations, then it's probably not enough. Read on to get up to speed on this emerging field.
This video teaches viewers how to encrypt an external drive that requires a password to read and edit the drive. All tasks are done in Disk Utility. Plug in the external drive you wish to encrypt: Make sure all previous data on the drive has been …
This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…
Suggested Courses
Course of the Month19 days, 22 hours left to enroll

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question