>We are experiencing incredibly slow VFP6 table record writing performance on a brand new Dual Xeon P4 2.4Ghz rig with 15k IBM Deskstars in a RAID5 Config. 1GB of Micron DDR is installed. All hardware has been tested and burnt in. We have tried our record writing tests without the RAID5 config and just one scsi drive. Still slow. The Adaptec controller is an AIC-7899 and is integrated onto the Intel 7500WV2 Motherboard. The RAID controller is an Intel SRCMR. When I say "Slow" I mean that the 15k SCSI writes records in VFP6 slower than the equivalent setup with an IDE hardrive. Now thats slow! Intel Tech is leaning towards this being a Foxpro problem with new SCSI hardware because write performance in any other "write" situation is 10x faster than in Foxpro. Also, there is no performance difference when using VFP7.

If there's any antivirus program active, try disabling it.

Other than that, VFP does not deal directly with the hardware, it can't even tell if a drive at a drive letter or UNC name is IDE, SCSI or whatever. Any such differences are under the control of the operating system plus any third-party utilities that hook into the file system (like the AV scanner).

Also make sure your system is performing as advertised. Do some other write tests outside of VFP.

And, make sure you're comparing apples to apples. For example, it might be possible that the SCSI RAID setup is configured to totally prevent write-behind caching, while the IDE has it turned on. In that case the IDE drive could well record better write performance.