Is this Visual FoxPro 6.0? or 5.0?
M.
>Hi,
> I have a query as the following:
>
>
>SELECT m.Card_No, m.E_Name, m.Off_Code ;
>FROM Member m ;
>WHERE m.Card_No NOT IN ;
> (SELECT Card_No ;
> FROM (lcRedeem) WHERE Redeem_Set_No = lcSetNo) ;
>GROUP BY m.Card_No INTO CURSOR csrSummary
>
>
>
>It is not optimized since that is a NOT condition. When I run it from my application, I work fast when I run it for the 1st time! It returns 5000 records within 3 seconds through LAN. However, it becomes slow for the second time. It take 10 seconds to query.
>
>Any ideas?
>
>Thank you
Marty Smith, CSQE