Lazy Insert Query
-
I've two tables and while insertion I've to face lazy response. The query takes much time to insert record. Any suggestion is welcomed. I'm usiing SQL Server 2000. Thanks
Syed Shahid Hussain
-
I've two tables and while insertion I've to face lazy response. The query takes much time to insert record. Any suggestion is welcomed. I'm usiing SQL Server 2000. Thanks
Syed Shahid Hussain
Syed Shahid Hussain, What are you asking for? Ways to speed up the insert? Well, you'll need to give us some code to see what you currently do, and how many rows are you inserting?, also, have a google for Bulk Copy (BCP) or read http://www.codeproject.com/KB/database/SqlBulkCopy.aspx[^]
-
I've two tables and while insertion I've to face lazy response. The query takes much time to insert record. Any suggestion is welcomed. I'm usiing SQL Server 2000. Thanks
Syed Shahid Hussain
one way you can speed up insertion is using stored prcedure which is precompiled code. try to use store proc plz
Abdul Rahaman Hamidy Senior Student Student in Computer Science Kabul, Afghanistan Software Developer
-
I've two tables and while insertion I've to face lazy response. The query takes much time to insert record. Any suggestion is welcomed. I'm usiing SQL Server 2000. Thanks
Syed Shahid Hussain
Hi syed, You can check 1. whether over indexing is used in the table. 2. use stored procedure. 3. whether u r inserting multiple records at a time? 4. please give complete picture of your work.
Sarvesh Upadhyay Senior Software Engineer Birlasoft India Ltd. Microsoft Certified Professional Developer in Dotnet 2.0 Enterprise Application