I'd stick with using tables. With a cursor, it's possible the data will be in memory anyway.
>I posted this under VFP syntax and didn't get any hits. So, I thought I'd try here. I'm a new to VFP & OOP. Here's the question:
>I am planning a personal project that will consist of numerous, time series, table field calculations using one or more tables. In planning for the project, I want to maximize calculation/computation speed (in DOS, I used a “virtual RAM drive”, copied my clipper tables and programs to the drive, did computations in RAM, then wrote results back to the C: drive).
>In VFP
>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
>
>OR
>
>Is it better to copy each table to an Array with the Copy to Array command,
> make up an index system which references the table fields numerically,
>do the required calculations in RAM,
>then fill a table with the Append from Array command?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer