能否在分表查询再做一次优化？

DotNetNext / SqlSugar

.Net aot ORM Fastest ORM Simple Easy VB.NET Sqlite orm Oracle ORM Mysql Orm 虚谷数据库 postgresql ORm SqlServer oRm 达梦 ORM 人大金仓 ORM 神通ORM C# ORM , C# ORM .NET ORM NET5 ORM .NET6 ORM ClickHouse orm QuestDb ,TDengine ORM,OceanBase orm,GaussDB orm ,Tidb orm Object/Relational Mapping

https://www.donet5.com/Home/Doc

MIT License

5.17k stars 1.32k forks source link

能否在分表查询再做一次优化？ #1226

Closed supersdar closed 4 months ago

supersdar commented 4 months ago

我实验了以下分表的查询时发现：即使是使用被[SplitField]标注的属性去查询，也会对每个分表都产生一个select 操作。能不能做到根据[SplitField]属性生成定向的sql语句？

DotNetNext commented 4 months ago

每次生成什么样的SQL截图

DotNetNext commented 4 months ago

线下已解决可以通过各种方式过滤表