C#窗口应用程序的SQL数据库性能 [英] Sql Database Performance with window application of C#

问题描述

大家好，

在我在数据库的城市表中输入13个城市之后，我的窗口应用程序运行良好(性能良好).

突然，数据传输速度变得非常慢.

任何提高SQL Server 2008性能的技巧/窍门.

问候！
Aman

Hi All,

My window application was working well (with good performance) until I have entered 13Lac cities in my city table of Database.

Suddenly, The data transfer speed became very slow.

Any tip/trick to increase SQL Server 2008''s performance.

Regards!
Aman

推荐答案

有很多技巧/窍门，但是，您需要提供更多信息.表的结构是什么?您在使用存储过程吗?您有什么索引?

There are plenty of tips/tricks, however, you need to provide more information. What is the table structure? Are you using stored procs? What indexes do you have?

添加一些有关索引和性能的详细信息.

您尝试索引了吗?！
http://msdn.microsoft.com/en-us/library/ff647793.aspx [ ^ ]

Add some more details on indexes and performance.

Did you try indexing?!
http://msdn.microsoft.com/en-us/library/ff647793.aspx[^]

这篇关于C#窗口应用程序的SQL数据库性能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！