Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append from delimited slow
Message
From
19/08/2014 08:51:13
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
 
 
To
18/08/2014 12:04:46
Walter Meester
HoogkarspelNetherlands
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01605731
Message ID:
01606060
Views:
61
>>>>>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform