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:
00277193
Views:
27
>>>>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

Yeah, you're probably right on that. I remember when 91k records was a lot!<g>
Now I've got apps with over 1 million records.
John Harvey
Shelbynet.com

"I'm addicted to placebos. I could quit, but it wouldn't matter." Stephen Wright
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform