>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.



Here is something to try. Create a Local View for your table. Set a filter in local view definition to a variable equal to a unique record id. Add the view to the Datasession and flag it as NO DATA on load in the properties of the DataSession. In the INIT of you form, set the variable and issue a requery() to populate the first record.

In you navigation buttons do the same. This will put the over head on the record move. Depending on your unique record key, you may need a second view of just your record keys so you know which record is next.

Hope this helps.