C#窗口应用程序的SQL数据库性能
问题描述：
大家好，
在我在数据库的城市表中输入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[^]