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:
00128299
Views:
30
>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?
Christopher Estep

When the student is ready, the master appears.
-- Chinese Proverb
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform