查询转类型问题 返回

单纯用sql查询2秒,不用转类型也是2秒,但是转ToListAsync运行时间就变成1.4分钟了!求教如何解决
热忱回答(4)
-
fate sta VIP0
2024/12/10https://www.donet5.com/Home/Doc?typeId=2361
0 回复 -
fate sta VIP0
2024/12/10升级sqlsugar最新,按上面链接排查
0 回复 -
.NET开发的小 VIP0
2024/12/10@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分钟
sqlsugarcore是最新的 这种也包含在内对吧
0 回复 -
fate sta VIP0
2024/12/100 回复