Am buying some new hardware to run a Foxpro app. Selects, scans, and
sorting on a table approx 500K records. Is there an advantage to XEON
processor for this? I've had mixed reports. What do you think is the
single most advantageous upgrade you could do for a VFP db? RAM?
Processor? Hard drive speed?

Thanks.

Monica

Your specs don't sound critical and Vfp in general has quite
a small footprint, runs happily on "any" kind of hardware.

Depends ...
IMO, Network speed and reliability are important.

- Client PC in a LAN
Vfp does intensive caching, so RAM and Cache (level 1,2,3)
size, quality and single- vs. dual-channel bus speed, are
almost always more important than HDD and CPU brand and
frequency (because with a "usual" app CPU usage might be
quite low in average, as shown by the Win TaskManager for
example, hard disk access is low (only accessing the local.exe
and runtime files every here and then, at startup first of all;
temp files occasionally later, they should reside on local HDD).

- File Server
HDD speed is more important, SCSI 15000 rpm disks are
quicker and louder than IDE 5400 rpm, RAID level makes a
difference.
- Web Server
Multiple CPUs, one per COM server instance, can be useful
and a lot of RAM.


hth
-Stefan


"Monica J. Braverman" <monica (AT) datashark (DOT) net> schrieb im Newsbeitrag
news:d70cd025.0406171712.2f75e8cf (AT) posting (DOT) google.com...