Re: SQL Azure insert speed

2013-04-18 Thread Greg Keogh
(This message was stuck in my drafts folder from yesterday. Thanks to confusion in Gmail I don't know if it went out, but here's a copy just in case it didn't.) Ian, a quick follow-up: I tried Azure Explorer and noticed it only manipulates blobs, albeit with a nice Explorer style UI. The Neudesic

Re: SQL Azure insert speed

2013-04-17 Thread Greg Keogh
> > It was announced on the Red Gate twitter account recently - > https://twitter.com/redgate/status/322394630836592640 > What's Twitter? I think had account on that thing for about 2 weeks back in 2006 when it was trendy. All it seemed to tell me was what colour undies supermodels were wearing th

RE: SQL Azure insert speed

2013-04-17 Thread Greg Low (GregLow.com)
01410 mobile│ +61 3 8676 4913 fax SQL Down Under | Web: <http://www.sqldownunder.com/> www.sqldownunder.com From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Keogh Sent: Thursday, 18 April 2013 10:14 AM To: ozDotNet Subject: Re: SQL Azure insert s

Re: SQL Azure insert speed

2013-04-17 Thread Craig van Nieuwkerk
Cerebrata is now owned by Red Gate. On Thu, Apr 18, 2013 at 10:14 AM, Greg Keogh wrote: > Hi Ian, I found this: > > http://www.cerebrata.com/labs/azure-explorer > > But I can't find a Red Gate Azure Explorer, unless this is the same thing. > I have been playing with Azure Storage Explorer versi

Re: SQL Azure insert speed

2013-04-17 Thread William Luu
Hi Greg, It was announced on the Red Gate twitter account recently - https://twitter.com/redgate/status/322394630836592640 On 18 April 2013 10:14, Greg Keogh wrote: > Hi Ian, I found this: > > http://www.cerebrata.com/labs/azure-explorer > > But I can't find a Red Gate Azure Explorer, unless t

Re: SQL Azure insert speed

2013-04-17 Thread Greg Keogh
Hi Ian, I found this: http://www.cerebrata.com/labs/azure-explorer But I can't find a Red Gate Azure Explorer, unless this is the same thing. I have been playing with Azure Storage Explorer version 5 preview 1 from Neudesic, which is simple and clean, but I haven't pushed it very hard. Wait, han

RE: SQL Azure insert speed

2013-04-17 Thread Ian Thomas
Red Gate has a new tool (free) that might be of interest: Azure Explorer is a new free tool that lets you manage Windows Azure storage like local files. You can manage Azure blobs, upload, download, transfer, and search. _ Ian Thomas Victoria Park, Western Australia

Re: SQL Azure insert speed

2013-04-14 Thread Greg Keogh
Dr L I hd to run some searches on what you mentioned and thanks to BACPAC I came up with this: http://msdn.microsoft.com/en-us/library/windowsazure/hh335292.aspx How to: Import and Export a Database (Windows Azure SQL Database) Which says: *If you want to import an on-premise SQL Server databas

Re: SQL Azure insert speed

2013-04-14 Thread Craig van Nieuwkerk
Another thing to remember is that SQL Azure replicates your data to three databases on different servers. This has to happen before a commit can be successful and so can effect performance. On Sun, Apr 14, 2013 at 5:56 PM, Greg Keogh wrote: > Folks, I'm using EF4 to insert 3900 rows in to a tab

RE: SQL Azure insert speed

2013-04-14 Thread Greg Low (GregLow.com)
Behalf Of Greg Keogh Sent: Sunday, 14 April 2013 5:57 PM To: ozDotNet Subject: SQL Azure insert speed Folks, I'm using EF4 to insert 3900 rows in to a table. Due to a performance quirk/bug in EF I have to insert them in groups of 50 with a fresh context for each group. In SQL Server and SQ

SQL Azure insert speed

2013-04-14 Thread Greg Keogh
Folks, I'm using EF4 to insert 3900 rows in to a table. Due to a performance quirk/bug in EF I have to insert them in groups of 50 with a fresh context for each group. In SQL Server and SQLite all rows insert in about 2 minutes. With an identical table in SQL Azure the same inserts take about 20 mi