查询性能问题 [英] Query Perfomance Issue

问题描述

嗨专家!!!



i在C＃.net中开发了windows base应用程序，并使用SQl服务器作为数据库。





它的工作完美，而记录高达20000但是当记录为150000时性能太慢。



plz给出任何建议！





谢谢，

Tarun

解决方案

您的查询不明确，但您可以对列应用索引，如果要将数据显示到任何控件，则使用分页。仅获取所需的数据。获取这么多数据是没用的。

阅读以下索引优化：

http://databases.about.com/od/sqlserver/a/indextuning.htm [ ^ ]



http://stackoverflow.com/questions/604879/how-can-i-learn-sql-server -index-tuning [ ^ ]



http://msdn.microsoft.com/en-us/library/ff650692.aspx [ ^ ]



http://msdn.microsoft.com/en-us/library/aa933123%28v=sql.80%29.aspx [ ^ ]

Hi expert!!!

i developed windows base application in C#.net, and use SQl server as Database.


it''s work perfect while record up-to 20000 but when record is 150000 then performance is too slow.

plz give any suggestion!!!


Thank you,
Tarun

解决方案

Your query is not clear but you can apply Indexes on columns and If you are displaying data into any control then use paging. Fetch only data which are required. Fetching this much of data are useless.

Read the following on index optimizations:
http://databases.about.com/od/sqlserver/a/indextuning.htm[^]

http://stackoverflow.com/questions/604879/how-can-i-learn-sql-server-index-tuning[^]

http://msdn.microsoft.com/en-us/library/ff650692.aspx[^]

http://msdn.microsoft.com/en-us/library/aa933123%28v=sql.80%29.aspx[^]

这篇关于查询性能问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！