RE: Azure DB performance

2010-11-23 Thread Ian Thomas
Assuming you have plain ADSL+ and not something less asymmetric such as Annexe M or Bonded DSL, or better - you would expect perhaps 20 times worse performance on upload just because of the internet connection. 5mins to 2 secs = 30 times. _ Ian Thomas Victoria Park, Western Australia

Re: Azure DB performance

2010-11-23 Thread David Connors
Best adsl2+ would be 24mbps / 1mbps 24 / 1 for annex A, 24 / ~2-3 for annex M. Is 4 am too early for a nit pick?

Re: Azure DB performance

2010-11-23 Thread David Connors
On 24 November 2010 04:12, David Connors da...@codify.com wrote: Best adsl2+ would be 24mbps / 1mbps 24 / 1 for annex A, 24 / ~2-3 for annex M. Is 4 am too early for a nit pick? Doh! Missed your early post on this thread - sorry (grumbles about iPhone threading being backwards :) --

RE: Azure DB performance

2010-11-23 Thread Greg Keogh
I claim my estimates of 5 minutes for insert of 1177 rows vs 2 seconds the select * is in the correct range. I have ADSL2 via Exetel. The insert calls were inside a DataReader loop and I had prepared the DataCommand parameters outside of the loop, setting the values inside the loop. I’m sure