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:
00128299
Vues:
31
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform