I wrote about my 800M DBF where queries would run quickly (less
than 2 secs) for a while, then take 5 minutes or longer while
there were thousands and thousands of page faults. You then
queried:

>>Is the slow query a complex single query? In VFP we have been
>>noticing that multiple simple queries execute much faster then
>>a single complex query.

Somebody else answered this question, but they weren't talking
about my problem. Here's my answer:

SELECT Field1 FROM MyDBF WHERE State="CA" INTO CURSOR MyCur ORDER BY Field2

Indexes are on Field1, State, and Field2 -- a very basic query.
The query is irrelevant, though. The problem rears its head
after any random sequence of queries. I'm following up on the
memory issues others have suggested.

- Will Schmidt