Yes i am atm, since it's just a quit check to run a query, but would this explain the SQL executing this slowly?
I know i'm not using any "best" practises and things, this is the first thing im doing with both NHibernate and EF. Here is the code running it. Configuration cfg = new Configuration(); cfg.Configure(); cfg.AddAssembly(typeof(Debiteur).Assembly); ISessionFactory factory = cfg.BuildSessionFactory(); ISession session = factory.OpenSession(); IList<Debiteur> lijst = session.CreateCriteria(typeof (Debiteur)).List<Debiteur>(); dataGridView1.DataSource = lijst; On 12 aug, 13:22, Kim Johansson <hagbarddenst...@gmail.com> wrote: > Are you creating a new SessionFactory each run? (SLOOOOOOOOOOOW!!!) > > You should use a single instance SessionFactory and just create new > sessions. > > F.B. ten Kate wrote: > > Hello there, im currently looking at some differences between both > > ORM's and to get a good feel for both i try to query from one table > > and simply drop all the data in a DataGridView. > > > Easy as pie right? > > > Now here is the different SQL's beeing generated > > > NHibernate: > > > "SELECT this_.Debiteur_ID as Debiteur1_0_0_, this_.Debiteurnaam as > > Debiteur2_0_0_, this_.Entiteit_ID as Entiteit3_0_0_, this_.Sorteernaam > > as Sorteern4_0_0_, this_.DatumWijziging as > > DatumWij5_0_0_, this_.Actief_NeeJa as Actief6_0_0_ FROM tbl_Debiteur > > this_" > > > Enitity Framework: > > > "SELECT > > [Extent1].[Actief_NeeJa] AS [Actief_NeeJa], > > [Extent1].[DatumWijziging] AS [DatumWijziging], > > [Extent1].[Debiteur_ID] AS [Debiteur_ID], > > [Extent1].[Debiteurnaam] AS [Debiteurnaam], > > [Extent1].[Entiteit_ID] AS [Entiteit_ID], > > [Extent1].[Sorteernaam] AS [Sorteernaam] > > FROM [dbo].[tbl_Debiteur] AS [Extent1]" > > > Okay, so sofar EF wins in readability atleast but i dont intend to > > actually look at the queries so i'm not worried. > > > I noticed that NHibernate was ALOT slower then EF, the reasons seemed > > like a mistery to me so i ran SQL Profiler. > > > When i run the NHibernate project the query runs for a duration of > > 19369 (milliseconds) > > > Then i run Enitity frame work which runs for a duration of 3621 > > (milliseconds) > > > (I clear caches between the different queries) > > > I then run the query in SQL Management Studio, The NHibernate has a > > duration of 4291 (milliseconds) > > I do the same for the Enitity framework which has a duration of 4291 > > (milliseconds) > > > Can anyone explain to me these durations? mostly the NHibernate time > > when running it from application code is HUGE. Eventhough the SQL is > > exactly the same... --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to nhusers@googlegroups.com To unsubscribe from this group, send email to nhusers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---