Databases
StackOverflow2013
Postsdbo
POWhy is EF4 Code First so slow when storing objects?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWhy is EF4 Code First so slow when storing objects?
    primarykey
    data
    text
    <p>I'm currently doing some research on usage of db4o a storage for my web application. I'm quite happy how easy db4o works. So when I read about the Code First approach I kinda liked is, because the way of working with EF4 Code First is quite similar to working with db4o: create your domain objects (POCO's), throw them at db4o, and never look back.</p> <p>But when I did a performance comparison, EF 4 was horribly slow. And I couldn't figure out why.</p> <p>I use the following entities :</p> <p><pre><code></p> <p>public class Recipe { private List _RecipePreparations; public int ID { get; set; } public String Name { get; set; } public String Description { get; set; } public List Tags { get; set; } public ICollection Preparations { get { return _RecipePreparations.AsReadOnly(); } }</p> <pre><code> public void AddPreparation(RecipePreparation preparation) { this._RecipePreparations.Add(preparation); } } </code></pre> <p>public class RecipePreparation { public String Name { get; set; } public String Description { get; set; } public int Rating { get; set; } public List Steps { get; set; } public List Tags { get; set; } public int ID { get; set; } }</p> <p></pre></code></p> <p>To test the performance I new up a recipe, and add 50.000 RecipePrepations. Then I stored the object in db4o like so : </p> <pre><code>IObjectContainer db = Db4oEmbedded.OpenFile(Db4oEmbedded.NewConfiguration(), @"RecipeDB.db4o"); db.Store(recipe1); db.Close(); </code></pre> <p>This takes around 13.000 (ms)</p> <p>I store the stuff with EF4 in SQL Server 2008 (Express, locally) like this :</p> <pre><code>cookRecipes.Recipes.Add(recipe1); cookRecipes.SaveChanges(); </code></pre> <p>And that takes 200.000 (ms)</p> <p>Now how on earth is db4o 15(!!!) times faster that EF4/SQL? Am I missing a secret turbo button for EF4? I even think that db4o could be made faster? Since I don't initialize the database file, I just let it grow dynamically.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USSaab
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POWhy is EF4 Code First so slow when storing objects?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POWhy is EF4 Code First so slow when storing objects?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POWhy is EF4 Code First so slow when storing objects?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COMy guess is that the overhead of many single insert-statements being executed is the largest portion of the difference. Is there a way to instruct EF4 to combine insert-statements to reduce that overhead?
      singulars
      1. POWhy is EF4 Code First so slow when storing objects?
      1. USLasse Vågsæther Karlsen
    2. CO@Lasse: Yes, there is. EF implements the unit of work pattern out of the box - see my answer.
      singulars
      1. POWhy is EF4 Code First so slow when storing objects?
      1. USTomas Lycken
    3. COI have done some profiling with Visual Studio. And the cookRecipes.Recipes.Add(recipe1) take approx 65% of total time to store, and SaveChanges approx 35% (duh... ;) ).
      singulars
      1. POWhy is EF4 Code First so slow when storing objects?
      1. USSaab
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload