>>1. Build temp table from table definition
>>2. Import new data provided from outside source
>>3. Index (answering your question, yes, on fresh data)
>>4. Rename old table
>>5. Rename temp table to bring it "live"
>
>Seems to me that this may be faster (and close to what Ken was asking for) if you changed the process to:
>
>1. Build temp table from definition
>2. Index temp table (define indices before import)
>3. Import new data (Fox updates all indexes simultaneously in background)
>4. Rename old table
>5. Rename temp table to live table name
>
>This is untested, just brainstorming, and may be considerably slower, not faster, for all I know. In fact, I may have read tips from various experts (Goley?, Hennig?) that my suggestion is the bad way, and Ken's process is the fast way...
>
>Will be very interested in your reactions...
>
>Rich.
You're right! This will be a pig. Creating the indices before appending the million + records will cause VFP to have to update every index as it is adding records. He's done about all he can do with the exception of putting this in the NT scheduler and making it happen automatically.
John Harvey
Shelbynet.com
"I'm addicted to placebos. I could quit, but it wouldn't matter." Stephen Wright