Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Optimizing a SQL Insert statement
Message
De
22/03/2006 10:35:06
Stephen Hunt
Admit Computer Services Inc.
Farmingdale, New York, États-Unis
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Titre:
Optimizing a SQL Insert statement
Divers
Thread ID:
01106642
Message ID:
01106642
Vues:
77
I was wondering if anyone had any tips on Optimizing SQL Insert statements.
I wrote a conversion from an older legacy database system and the conversion seems real slow. I narrowed the delay down to the SQL Insert commands. Does anyone have any tips that could speed up this process ?

Insert into persons (per_name,per_address,per_city,per_state,per_zip) values
'John Smith','123 any street','any city','NY','11876')

Thanks !
Stephen J. Hunt
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform