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