I have a VFP/MySQL system.

In the Mysql I have a table (customer) with 140000 lines, when I try to create one view remote or to have access one that uses tables with many lines the VFP delays very to have access.

It does not stop reading the data (therefore with SPT it functions very fast), to only have access view remote (nodataonload=.t.) What it can be happening to be so slow?

This occurs in version 7 and 8