Create the indexes first-otherwise fox is having to index on the fly in the query. with 2 mil records and no index and pulling 1/30 of the records this will be very slow without the index!
I make it a practice that when I delete a record I BLANK the record also. this way it is not included in any queries etc. I don't reuse records so my nitetime job searches the dbf's for a blank key field, deletes it and then packs.
Dave
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.