Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Speed up appending/indexing?
Message
From
03/04/2002 16:21:46
 
 
To
03/04/2002 15:38:00
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00640552
Message ID:
00640595
Views:
13
Consider deleting all the index tags prior to the APPEND and then recreating the index. You might be surprised in that this may indeed be faster than keeping the original index tags.

You can create a UDF() and call it on the FOR clause of an append from. While this will give the user a message, it will by definition slow things down...

>Hi everyone,
>
>I have a FPW2.A table with 5.7 meg records and I have to append about 40K records in one shot, once a week. I have seven indexes for the table which I only use to retrieve SELECTed data. The table seems optimized fairly well at this point since it typically takes less than one second to get the data.
>
>The problem is it's taking around fifteen minutes to append the new records. It's the indexing that's taking the time.
>
>The questions are:
>1. Can this be sped up?
>2. Is there a way to indicate that something is happening, like "Appending Records"; "Indexing Index##" and the like? Maybe a progress bar? Something instead of the non-informative hourglass.
>
>Any advice and smart-alec comments appreciated.
>TIA,
>Pete
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform