I recently upgraded an application from 2.6 to VFP 6. With one exception, it is a major improvement. Unfortunatley, the exeption is a major problem. I belive the problem is due to a) in 2.6, a record was only loaded to memory (MEMVAR) when the pointer reached the record. b) it seems in 6, the entire data environment is loaded prior to the window loading. The screen set that is the problem has a data environment approximatley 600 MB ( 600 records, with 2 high res JPG photos per record). This makes load time extremly slow, if there is enough swap space left on the HDD. Unlike remote views, I cannot find a way to force it to only load a few records at a time. This is a read only form set, used to display the data to a TV studio output on live TV. During the broadcast, we use a much better box, but a ten minite data load to recover from a possible crash in the middle of a live broadcast is not tolerable.
Any suggestions on how to speed the data load or shrink the number of records fetched at one time will be greatly appreciated.