Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Seconds to append 91K records: 60? 135? 1900?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00276272
Message ID:
00277183
Views:
26
>>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform