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 |
|
lalbatros
Yak Posting Veteran
69 Posts |
 Posted - 2010-04-10 : 16:54:06
|
| Hello,I am using AdoDb/sqloledb in read-only to download a table of about 30k records from an sql server database.At work the network is excellent (10 Mbps up, 10 Mbps down) and the download takes 4 seconds. (network tested on speedtest.net)At home, my connexion is not so bad in download (0.4 Mbps up, 3.0 Mbps down). Yet, the download of the table takes more than 80 seconds. I would have expected 12 seconds based on the network tests.Do you think there is room to improve somehow the download performance when I am at home? Or is there something wrong in my test?If there is some hope from improvement, what would you suggest?Thanks,MichelPS:===I do this download to an Excel 2003 sheet.Using the Excel queries, is much slower, 50 seconds at work.I tested already different options without results.For example, I used the "CopyFromRecordset" method without changibg the performance as compared to a record-by-record VBA code.I also modified the cachesize property of the recorset object without improvements. |
|
|
|
|
|
table download performance depending vs network