×

Loading...
Ad by
  • 最优利率和cashback可以申请特批，好信用好收入offer更好。请点链接扫码加微信咨询，Scotiabank -- Nick Zhang 6478812600。
Ad by
  • 最优利率和cashback可以申请特批，好信用好收入offer更好。请点链接扫码加微信咨询，Scotiabank -- Nick Zhang 6478812600。

@Calgary

The performance also definitely depends on data provider. IBM data provider of course is very good one to deal with DB2. So you don’t have change to improve performance here.

deep_blue(BLUE)
In order to prevent connection leaking problem, any database operation should open and close in one unit operation by default. That is also smart not stupid. Please read Performance Considerations for Entity Framework Applications from following url: http://msdn.microsoft.com/en-us/library/cc853327.aspx. Hope you can get some hint there.

Generally speaking, performance of entity framework is better than LINQ but poorer than directly SQL.

If the performance of your operation does affect your whole operation, you might think about to use SQL rather than entity framework.
(#5875525@0)
Last Updated: 2010-2-10
This post has been archived. It cannot be replied.
Report

Replies, comments and Discussions:

  • 工作学习 / 学科技术讨论 / entity framework 和 DB2 用的时候效率比较低啊，特别是当 update 一个 entity with many children (1 to many) 的时候。做了 performance profile 发现都是 TryGetObjectByKey 和 SaveChanges 用的最多，有没有好的方法提高一下？ -sowen(昂居居); 2010-2-4 (#5860785@0)
    • My two cents -deep_blue(BLUE); 2010-2-5 {269} (#5864385@0)
      In your situations, object Services must continuously open and close the connection to the data source. You can consider manually opening the connection at the start of these operations and either closing or disposing of the connection when the operations are complete.
      • I doubt it -sowen(昂居居); 2010-2-9 {857} (#5874214@0)
        usually people wrap the operation as follows:

        using (context = new )
        {
        Get;
        SaveChanges
        }

        sometimes there is another layer with transaction

        I don't think Microsoft is stupid enough to open a new connection per operation; it must be cached.

        But what you were suggesting is open the connection manually before I perform any operation, close it after the last one. I truly don't think that's necessary. However, I tried it anyway. According to the performance profile, it seems to be 1 second slower on average, I will respectfully say your suggestion doesn't make any difference.

        Please let me know if I misinterpret your idea.

        One option is to use compiled queries, but there is no (custom) query in our cases, mainly are SaveChanges and TryGetObjectByKey.

        We still feel the headache, any other hints? thanks
        • What data provider are you using? -deep_blue(BLUE); 2010-2-10 (#5874401@0)
          • IBM.Data.DB2.xxxx -sowen(昂居居); 2010-2-10 (#5874451@0)
            • The performance also definitely depends on data provider. IBM data provider of course is very good one to deal with DB2. So you don’t have change to improve performance here. -deep_blue(BLUE); 2010-2-10 {585} (#5875525@0)
              In order to prevent connection leaking problem, any database operation should open and close in one unit operation by default. That is also smart not stupid. Please read Performance Considerations for Entity Framework Applications from following url: http://msdn.microsoft.com/en-us/library/cc853327.aspx. Hope you can get some hint there.

              Generally speaking, performance of entity framework is better than LINQ but poorer than directly SQL.

              If the performance of your operation does affect your whole operation, you might think about to use SQL rather than entity framework.

More Topics

  • Torvalds patch improves Linux performance by 2.6%
  • GitHub Spark
  • 脑洞大开，突发奇想，用力来传播信息
  • 看大家讨论日语，俺也正在认真学习。其实语言问题应该是很快也很容易就解决的，可能比自动驾驶来的还快。TREK里面，全宇宙的人都在大脑里安装了UNIVERSAL TRANSLATOR，外星人之间相互交流无障碍。废话少说，看视频。。。加上个MIC和耳机，不同国家的人就可以无障碍交流。
  • 肉脸真有搞 IT 的？Linux 把俄国中国伊朗踢出去了好像肉脸 IT 没啥感觉似的
    • 枫下论坛主坛 /  工作学习 /  学科技术讨论