获取100条记录需要两分钟 [英] Fetching 100 records takes two minutes

问题描述

我正在使用后端sql server运行Web应用程序。一张表显示记录很慢。你能告诉我原因吗？在sql server中有132条记录需要两分钟才能显示所有记录。

I'm running web application with back end sql server. One table is displaying records very slow . Can you tell me the reason? In the sql server there are 132 records it is taking two minute to show the all records.

推荐答案

Pfff，难题......这就像......我的汽车无法启动，我该如何解决..有十几个原因。


- 你的网络可能很慢

- The机器托管SQL Server可能需要更多资源

- 您的数据表设计可能很差

- 获取的数据量很大

- 你在查询中添加了一个看似缓慢的where子句



你能给我们一个提示吗？你测量的是你的数据库是慢的，还是显示接收数据的过程？

Pfff, difficult question... This is like... My car doesn't start, how can I fix it.. There's a dozen reasons.

- Your network may be slow
- The machine hosting SQL Server may need more resources
- Your data table design can be poor
- The amount of data being fetched is huge
- You add a where clause in your query which appears slow

Can you give us a hint what's going on? Did you measure it's your database that's slow, or maybe the process that displays the received data?

这篇关于获取100条记录需要两分钟的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！