Thanks for the info John! Unfortunately, all my views are local. This is terribly odd.
>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?