查询转类型问题 返回

SqlSugar 处理完成
4 450

单纯用sql查询2秒,不用转类型也是2秒,但是转ToListAsync运行时间就变成1.4分钟了!求教如何解决


热忱回答4

  • fate sta fate sta VIP0
    2024/12/10

    https://www.donet5.com/Home/Doc?typeId=2361

    0 回复
  • fate sta fate sta VIP0
    2024/12/10

    升级sqlsugar最新,按上面链接排查

    0 回复
  • @fate sta

     var dataQad = _dal._db.Queryable<Account, XgcrmcustomMstr, XcpPtXxptView, Account, XgpmieMstr, XgpmpvtypeMstr, XgpmapMstr, XgpmpvtypeMstr, XgpricelistMstr>(joinExpressionQad)

     .WhereIF(!string.IsNullOrEmpty(where.Item1), where.Item1, where.Item2)

     .Select(selectExpression); 2秒



     var dataQad = _dal._db.Queryable<Account, XgcrmcustomMstr, XcpPtXxptView, Account, XgpmieMstr, XgpmpvtypeMstr, XgpmapMstr, XgpmpvtypeMstr, XgpricelistMstr>(joinExpressionQad)

     .WhereIF(!string.IsNullOrEmpty(where.Item1), where.Item1, where.Item2)

     .Select(selectExpression).ToListAsync(); 1.4分钟



    image.png



    sqlsugarcore是最新的 这种也包含在内对吧

    0 回复
  • fate sta fate sta VIP0
    2024/12/10
    0 回复