You may want to set the buffer size for VFP using sys(3050) to something like 12MB...

sys(3050,1,12000000)
sys(3050,2,12000000)

Especially with SQL, this can vastly effect the memory performance.