>>Testing run on my network workstation (instead of on faster Server):
>>1st Query, FPW 2.6 = 91.56 seconds, VFP 5.0a = 184.55
>>2nd Query, FPW 2.6 = 373.25 seconds, VFP 5.0a = 399.46
>>3rd Query, FPW 2.6 = 2.47 seconds, VFP 5.0a = 4.34
>>
>>Tell me the correct way to use IN instead of EXISTS in the above code and I'll post results so we can see which is faster in this example. Much Thanks, this thread has really helped me!!
>
>SELECT azactive.offnum, azactive.acct AS account, azactive.name FROM azactive ;
> INTO CURSOR temp1 ;
> WHERE acct NOT IN (SELECT account FROM addunit)
>
>SELECT azactive.offnum, azactive.acct AS account, azactive.name FROM azactive ;
> Into Cursor temp2 ;
> Where acct NOT IN (Select account From azhandle)

OK, testing results using Ed's code above:
1st Query, 478.32 seconds
2nd Query, 612.15 seconds
3rd Query, 4.51 seconds (same query as original test, so it seems network is maybe slowing down as the day goes on)

I'm guessing this is Not the results we should expect. Another note, during all three tests I kept an eye on Users attached to my Server by using NT Server Manager to see who was accessing which resources. The only time anybody other than me was using this Server was during the FPW 2.6 tests, and I have a 100mps connection between my worstation & server. I dont have much confidence in these results so I'm going to reboot my workstation and try VFP tests a few more times. Any thoughts as to why things got slower would be appreciated.