>>>Have you applied Visual Studio 97, SP 3 to VFP 5.0?
>>
>>
>>Ah, that does ring a bell. No, I've downloaded it but I haven't applied it.
>>
>>Thanks for the reminder.
>>
>>Peter
>
>Try delete tag all before appending, then rebuild the indices. It will be faster than updating the indices while appending the data.
You are correct, and I have used that trick at times. I even have a little function I call Tags_RS() which will generate the code necessary to rebuild the indexes.
But the main point here is that when the system is running the way it is capable of (over 600 appends per second) the whole 91,000 records can be loaded in less than 3 minutes. Fast enough that I don't need to bother with removing the indexes.
Peter
Peter Robinson ** Rodes Design ** Virginia