Willie,

Make sure your queries meet all the optimization criteria. An index tag on DELETED() if you have SET DELETED ON. Matching index expressions for the JOINS and WHERE clauses. VFP is quite capable of returning result sets from multimeg record tables in a few seconds. I have a test data file that's 1.1 meg records about 44 meg of data and the queries all run very fast.

>My problem is this, the data is on a NT 4 box and I have 2 do queries/subtract info out of this table. I'v tried SELECT but that was realy very, very slow. Then I used the SET FILTER. A lot better, but far to slow.