Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Inserting large amounts of data
Message
De
07/07/2000 16:20:54
Charlie Schreiner
Myers and Stauffer Consulting
Topeka, Kansas, États-Unis
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00389512
Message ID:
00389663
Vues:
13
Hi Pat,
Remember this.
APPEND BLANK, REPLACE, REPLACE - Very slow, CDX may need to be updated 3 times.

INSERT INTO - Better, CDX only is updated once per record. Still a lot of network traffic in that a CDX lock and a DBF Header lock are needed for each record inserted.

APPEND FROM - Best since DBF Header is locked only once for all records. CDX update may occur only once as well. I don't know this is true, but it would may sense since no other user would even know the new records exist until the append has completed and the DBF header is unlocked.

If you can use the Table exclusively, so much the better.

>I have a form that is reading data from several text files and inserting it into tables. It has been running for 26 hours so far. I have a wait window that is showing me a counter. I have noticed that it is getting slower and slower the longer it runs.
>
>Is there anything I can do to prevent it from slowing down?
>
>Thanks
>
>Pat Murphy
Charlie
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform