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 |
|
hellilyntax
Starting Member
19 Posts |
 Posted - 2006-08-06 : 14:28:10
|
hi guys,before i come to my problem, ill let you know my app architecture.i have a vb program to update my sql server database which is located at hosting company.the program will transfer every rows in Excel on local pc to MSSQL table on server.the problem is, it takes too long to complete the transaction because it involves thousands of rows (up to 10000). when i try, it only can execute 800 rows and the connection will break.do you have any idea to overcome this...is there anything to do with 1. connection speed2. sql statement3. architecture itself 4. is it possible to execute 10000 rows over the net?  5. do i have to have the SQL Server on local so that the journey can be faster?please give me some idea.... |
|
|
|
|
|
Connection Timeout