Hi Michael --

If it's a remote view, try setting FetchAsNeeded (via DBSETPROP()) to .T. this should limit the records to 1 unless explicitly requeried.


>I've noticed some performance problems with an app I'm working on. I never could determine the problem until I saw the latest issue of Foxpro Advisor which had an article discussing possible problems with SQL statements in VFP. My problem seems to be similar. For example, I have the following view:
>
>CREATE SQL VIEW lv_testview AS ;
>SELECT Address.ad_city, Address.ad_state, Address.ad_zip, Whstops.wh_id, Whstops.wh_refid;
>FROM hits!whstops ;
>LEFT OUTER JOIN hits!consigne ON Whstops.wh_conid = Consigne.o_id;
>LEFT OUTER JOIN hits!address ON Consigne.o_id = Address.ad_id ;
>WHERE Whstops.wh_id = ?vp_id
>
>
>If I issue: USE lv_testview NODATA it pulls about 10MB worth of data over the network. I have the network monitor showing all traffic over my ethernet card. I've tested this countless times with the same amount of data coming over every time.
>
>If I change my LEFT OUTER JOINs to INNER JOINs the view pulls about 200K of data. This would be great except for the fact that I need left outer joins. Does anyone have any idea what's going on here?