Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Optimizing a SQL Insert statement
Message
From
22/03/2006 10:35:06
Stephen Hunt
Admit Computer Services Inc.
Farmingdale, New York, United States
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Title:
Optimizing a SQL Insert statement
Miscellaneous
Thread ID:
01106642
Message ID:
01106642
Views:
76
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
Next
Reply
Map
View

Click here to load this message in the networking platform