Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Most effective way to insert many recs to SQL Server?
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00127997
Message ID:
00128383
Views:
40
>>Hello Chritopher,
>>
>> I would sugget you to use Remote Views table buffering enabled. First add all
>>records to the view and then update them using single TABLEUPDATE().
>>
>> This will reduce the number of transcation to the server as it write to it just in one shot.
>
>Ok, did that. The only catch was that it took about 20 minutes to do 25000 records. ACK! Any other suggestions before I take the route of optimizing the server?


Hi,

Just try to do it with SCAN .. ENSCAN. and insert/commit each row at a time.
See the difference and please get back to me with the results.

Bye
Jayesh
- Jayesh
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform