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
