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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement