Linq2SQL对NHibernate的表现(我疯了吗？)

Question

我编写了以下测试来比较Linq2SQL和NHibernate的性能，我发现结果有点奇怪。映射是直接向前的，两者都是相同的。两者都是针对一个动态数据库运行的。虽然我不删除竞选的情况下，林克，但这不应影响性能超过10毫秒。

林克：

    [Test]
    public void Test1000ReadsWritesToAgentStateLinqPrecompiled()
    {
        Stopwatch sw = new Stopwatch();
        Stopwatch swIn = new Stopwatch();
        sw.Start();
        for (int i = 0; i < 1000; i++)
        {
            swIn.Reset();
            swIn.Start();
            ReadWriteAndDeleteAgentStateWithLinqPrecompiled();
            swIn.Stop();
            Console.WriteLine("Run ReadWriteAndDeleteAgentState: " + swIn.ElapsedMilliseconds + " ms");
        }

        sw.Stop();
        Console.WriteLine("Total Time: " + sw.ElapsedMilliseconds + " ms");
        Console.WriteLine("Average time to execute queries: " + sw.ElapsedMilliseconds / 1000 + " ms");
    }

    private static readonly Func<AgentDesktop3DataContext, int, EntityModel.CampaignDetail>
        GetCampaignById =
            CompiledQuery.Compile<AgentDesktop3DataContext, int, EntityModel.CampaignDetail>(
                (ctx, sessionId) => (from cd in ctx.CampaignDetails
                                     join a in ctx.AgentCampaigns on cd.CampaignDetailId equals a.CampaignDetailId
                                     where a.AgentStateId == sessionId
                                     select cd).FirstOrDefault());

    private void ReadWriteAndDeleteAgentStateWithLinqPrecompiled()
    {
        int id = 0;
        using (var ctx = new AgentDesktop3DataContext())
        {
            EntityModel.AgentState agentState = new EntityModel.AgentState();
            var campaign = new EntityModel.CampaignDetail { CampaignName = "Test" };
            var campaignDisposition = new EntityModel.CampaignDisposition { Code = "123" };
            campaignDisposition.Description = "abc";
            campaign.CampaignDispositions.Add(campaignDisposition);
            agentState.CallState = 3;

            campaign.AgentCampaigns.Add(new AgentCampaign
            {
                AgentState = agentState
            });
            ctx.CampaignDetails.InsertOnSubmit(campaign);
            ctx.AgentStates.InsertOnSubmit(agentState);
            ctx.SubmitChanges();
            id = agentState.AgentStateId;
        }

        using (var ctx = new AgentDesktop3DataContext())
        {
            var dbAgentState = ctx.GetAgentStateById(id);
            Assert.IsNotNull(dbAgentState);
            Assert.AreEqual(dbAgentState.CallState, 3);
            var campaignDetails = GetCampaignById(ctx, id);

            Assert.AreEqual(campaignDetails.CampaignDispositions[0].Description, "abc");
        }

        using (var ctx = new AgentDesktop3DataContext())
        {
            ctx.DeleteSessionById(id);
        }
    }

NHibernate (循环相同)：

    private void ReadWriteAndDeleteAgentState()
    {
            var id = WriteAgentState().Id;
            StartNewTransaction();

            var dbAgentState = agentStateRepository.Get(id);

            Assert.IsNotNull(dbAgentState);
            Assert.AreEqual(dbAgentState.CallState, 3);
            Assert.AreEqual(dbAgentState.Campaigns[0].Dispositions[0].Description, "abc");

            var campaignId = dbAgentState.Campaigns[0].Id;
            agentStateRepository.Delete(dbAgentState);

            NHibernateSession.Current.Transaction.Commit();

            Cleanup(campaignId);

            NHibernateSession.Current.BeginTransaction();
    }

结果：

NHibernate:
Total Time: 9469 ms
Average time to execute 13 queries: 9 ms

Linq:
Total Time: 127200 ms
Average time to execute 13 queries: 127 ms

林克输了13.5次！具有预编译查询的事件(两个读取查询都是预编译的)。

这不可能是正确的，虽然我预计NHibernate会更快，但这有太大的差别，考虑到映射是相同的，而且NHibernate实际上对DB执行了更多的查询。

Update. --我已经重构了一个使用NHibernate而不是Linq2Sql的项目，与使用相同映射的测试相比，性能提高似乎要小得多(约20-30%)。有谁有自己的真实世界的例子吗？

Answer 1

在.NET代码和Server数据库上运行分析器。另外，确定在这两种方案的掩护下运行的SQL语句。LinqToSql的时间在哪里？如果底层SQL语句不同，为什么？很有可能，你可以调整两个ORM，使之更快。对于简单的测试，它们的性能应该大致相同。这感觉像是配置问题。