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 <[email protected]> wrote: > 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 minutes. > > Now either SQL Azure has insert performance problems, or my insertion > technique is not valid for Azure. If anyone here is using SQL Azure in > anger then I'm keen to hear of any performance problems and/or workarounds > you've found. > > Greg K >
