Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-09-10 : 08:13:56
|
| Saleem Subhi writes "Hi,when inserting data in a table i am getting the following error:Error : -2147217871 Source : Microsoft OLE DB Provider for SQL Server Descripion : Timeout expired Help Context : 1000440 The data is added through a stored procedure which is called under MTS from a dll which in turn is accessed through a ASP page. The table has arround 150,000 records. This is not a bluk insert. Why am i getting this error, is this a locking problem? Please reply ASAPThanking you." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-09-10 : 08:12:28
|
| On the off chance these two are the same person:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=29040 |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-09-10 : 19:39:01
|
| It's not a locking problem, it's probably due to the fact that each row is being inserted one at a time. If that's the case you'll always get a timeout. You'll also get better performance if you dump MTS, if all you're using it for is data manipulation. Never manage data transactions outside of the database unless and only unless there is a completely external process that must be part of the transaction.You can almost certainly speed things up by taking the data from your ASP page (who is actually BROWSING 150,000 rows of data on a web page anyway?) and writing it out to a flat text file, which you can then import using BULK INSERT or bcp. Don't be surprised if this is 100 times faster or more.Without more detail and some code I don't think we can help much more. |
|
|
|
|
|
|
Query Time out while inserting data