>Is it better to use table buffering by increasing buffering with:
>
>SYS(3050,1,16000000)&& sets foregnd buffering to 16mb,
>SYS(3050,2,16000000) && sets backgnd buffer to 16mb and then use
> The tableupdate: =CURSORSETPROP("Buffering",5) function
>


I agree with Craig. I also wanted to point out that increasing SYS(3050) doesn't necessarily speed things up. Sometimes, it has the opposite result.

SYS(3050) tells VFP how much memory it can use. If you tell it it has more than is really available, then VFP thinks it has memory, but is actually using a page file on disk. That can be very slow.

Mac Rubel did a great series of articles about all the tradeoffs between different settings a few years back in FoxPro Advisor. They're worth looking at.

Tamar