Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Append from delimited slow
Message
De
19/08/2014 08:51:13
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
18/08/2014 12:04:46
Walter Meester
HoogkarspelPays-Bas
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01605731
Message ID:
01606060
Vues:
60
>>>>>What can be done to allow an append, from a large delimited text file, to proceed at optimal speed?
>>>>>In some environments, my append slows way down.
>>>>
>>>>Use Local destination table/cursor w/o indexes
>>>
>>>Also you should run your .EXE at client's own HDD, not a server's HDD from client.
>>
>>I agree with Sergey. The location of the exe won't affect the speed of append from. However, for the same reason that a local exe is better than a remote one, it will be faster to append to a local cursor.
>
>That is only true if the cursor is not materialized (yet)
>
>If FILE(DBF("MyCursor")) returns .T. the cursor is flushed to disk. Then there is no difference between a cursor and a (local) DBF.

But still a huge difference between local disk and one on the network. And if the local disk is a SSD...

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform