>>Hi, just jumping in on this.
>>
>>Problem now is speed. Using the NOFILTER or the INTO TABLE means that the query now takes 90 seconds, instead of 90 milliseconds. I'm trying to retrieve about 400,000 records from a table with 1 million records in it. Surely this should be achievable in a very short time?
>>
>>Has anyone got any ideas?
>>
>>René.
>
>Do you have an index set on the table?
>Get rid of any Deleted() tags from the index
>What's the where clause in your select statement?
Oh yes. The query is:
SELECT dr_id FROM apptroster WHERE rosterdate>=date() .AND. site_id = 0
I have tried it with indexes on DELETED() and without, as well as using SET DELE ON (slow) and SET DELE OFF (very fast).
The table is also indexed on site_id, rosterdate and rosterdate>=date().
Basically, when using INTO TABLE or NOFILTER, it takes forever. I think it must be because VFP has to write 60 MB of data to the disk and that takes time...
Any feedback appreciated.
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