Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement