>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.
>
Here's two more cents--
This doesn't sound like a memory issue so much, after looking over the thread...I get swapping delays, but nothing like 2 sec to 5 min, more like 2 sec to 10 or 15 sec. It sounds more like an index is not being used for the query, or somehow optimization is off...