您要做的第一件事就是确定瓶颈在哪里.我的猜测是您的查询可以更好地构建，并且您确实应该使用存储过程，而不是直接从代码中进行存储.

顺便说一句，既然您的代码可以正常工作，则重构起来会变得更加容易.

站点下来，仔细考虑一下.

The first thing you have to do is determine where the bottlenecks are. My guess is that your queries can be better constructed, and you really should be using stored procedures instead of directly from code.

BTW, now that you have code that works, it will be easier to refactor to make it better.

Site down and think about it for a bit.

本文 5种基本方式可以提高性能 [ ^ ]帮助您.