We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
1,分页查count拼sql建议不要用子查询直接切割就好,有order by建议去掉order by查count没必要。 2,建议查分页和查list采用异步方式,最起码要有一个开关
The text was updated successfully, but these errors were encountered:
默认不用子查询,除非有聚合函数或group by。 默认会去 order by。
异步方式可以考虑,目前的逻辑中,如果 count = 0,就不会继续查询。
Sorry, something went wrong.
感觉查询时候还是有数据时候多,异步时候即使多查了一次,对性能影响并不大,所以建议增设分页时候异步开关,让用户自己选择。
19043df
No branches or pull requests
1,分页查count拼sql建议不要用子查询直接切割就好,有order by建议去掉order by查count没必要。
2,建议查分页和查list采用异步方式,最起码要有一个开关
The text was updated successfully, but these errors were encountered: