In my old Clipper programs (DOS environment) everything was in RAM (using a virtual drive). As a result all the Field/Column calculations (requiring many passes down the rows of each field/column) were done in memory with no input/output to the disk drive. Speeded up things by “light years” 9 hours of compution reduce to 45min. Final results then copied to disk in one I/O.
I want to accomplish this in VFP so my processing is speeded up. First, I thought table buffering accomplished that. Second, I thought increasing table buffer size would provide more memory set aside for this process. The Tableupdate() function then would commit changes from memory to the copy of the table on the disk.
I read your reply to mean that this is not the way it works. So, am I forced to use arrays to speed up processing, or is there something else happening with VFP?
Thanks for your interest & help.