>Hi All,
>
>I have a querie that looks like this:
>
>
>
>SELECT Ashky, Aslky ;
> FROM Pps ;
>WHERE Aslky IN (SELECT Aslky FROM Asl_List) ;
> AND PpsSa = 'U' ;
>INTO CURSOR Pps_list
>
>
>
>asl_list has 17 records, Pps has about 200,000 records. In VFP 8 the query runs in about 6 seconds. In VFP 9 it takes 14 seconds. I can't find anything in the "What's changed" section of the VFP 9 help file that would account for this performance degradation. Is there anything about Sub-Queries in VFP 9 that I'm missing?
>
>P.S. I know I could re-write the query joining the tables and get better performance, but I'm specifically curious about the performance hit in the query between the 2 versions of VFP, not how to re-write the query.
>
>TIA!
>
>Rob
Compare vfp8/9 SYS(3054,11), post differences.