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 |
|
sasan_vm
Yak Posting Veteran
51 Posts |
 Posted - 2011-12-24 : 07:09:30
|
| Hello, I have an database on SQL Server 2008 R2 a client daily register records local andnext day upload records with code like this://-----------------------------------------open_local_db();while (!EOF){ insert_remote_server(); move_next_record();}//-----------------------------------------May be for large amount of records cause problem in insertion for SQL Server ?Can be better after any record set an delay ? like this code.//-----------------------------------------open_local_db();while (!EOF){ insert_remote_server(); move_next_record(); sleep(100); // 0.1 second}//-----------------------------------------Kind Regards,sasan. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-24 : 07:11:50
|
| why cant they upload in batches? row by row insertion is much slower. How is record stored locally?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
sasan_vm
Yak Posting Veteran
51 Posts |
Posted - 2011-12-24 : 07:49:46
|
| Hello,The records containt BLOB filed also connection bandwith is so limited,locally store in SQL-Express.Regards,sasan. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-24 : 07:58:22
|
| ok..now why do you want delay between each record?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
sasan_vm
Yak Posting Veteran
51 Posts |
Posted - 2011-12-24 : 11:56:39
|
| I don't want delay, That is my question: May be without delay problem happens to sql server ? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-24 : 11:58:40
|
| what problem is happening without delay?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Remote insert records ?