Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Most effective way to insert many recs to SQL Server?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00127997
Message ID:
00128383
Vues:
41
>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform