>>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only