<div>
Most are 1GBit there may be a few stragglers still but not more than 2 or 3.
</div>


Most are 1GBit there may be a few stragglers still but not more than 2 or 3.

<div>
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.<br />
<br />
An important information is the application architecture and topology. How do you access your app and data?<br />
<br />
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.<br />
<br />
Also temporary files location can affect the application speed. 
</div>


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.

<div>
<div class="content wysiwyg-content">
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?<br />
<br />
Approximately 100 users<br />
Database size 4.2 GB
</div>
</div>


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

What raid configuration is best for a FoxPro database?

Computer data storage, often called storage or memory, is a technology consisting of computer components and recording media used to retain digital data. In addition to local storage devices like CD and DVD readers, hard drives and flash drives, solid state drives can hold enormous amounts of data in a very small device. Cloud services and other new forms of remote storage also add to the capacity of devices and their ability to access more data without building additional data storage into a device.

Storage

Visual FoxPro (VFP), and its predecessor FoxPro, is a data-centric, object-oriented, procedural, database programming language and IDE from Microsoft last released in 2007 that still has some active use due to its low cost of deployment and fairly rapid development. In 2008, Microsoft released a set of add-ons for VFP's xBase components to allow interoperability with various Microsoft technologies. It allows data processing against its native file-based data tables or database servers such as SQL Server.