关于SQL Server驱动程序 [英] About SQL Server drivers

问题描述

我可以使用SQL Server在asp.net应用程序中获得更好的性能.
我可以在SQL Server 2005中做什么以提高该应用程序的性能.
由于SQL Server中的性能，在任何应用程序中会引起什么问题.

请给我答案.

谢谢与问候
Ajay Lanjewar

Hi,

What can i do for better performance in the asp.net application using SQL Server.
What can i do in SQL Server 2005 for getting better performance of that application.
What is the issues raise in any application due to performance related in SQL Server.

Please give me the answer.

Thanks and Regards
Ajay Lanjewar

推荐答案

有很多想法可以使您获得更高的性能.未定义INDEX的SQL语句的特殊之处.

假设您有一个包含100.000行的表.如果搜索特定值，则为整数值.

There are many thinks where you can gain more performance. Special with SQL statements where there is no INDEX defined.

Imagine you have a table with 100.000 rows. If you search for at specific value, an integer value.

SELECT id FROM tbl WHERE age=10

查找所有行将花费xx的时间.它必须查看所有100.000行

但是，如果您对年龄"进行索引，则相同的SELECT语句将更快地找到行.它可以显示年龄"的索引，只需要查看8.000行

查看所有SQL语句，看看是否可以更快地执行它们.并且不要使用像
这样的SQL语句

Will take xx amount of time to find all rows. It has to look at all 100.000 row

But if you make a INDEX on "age", the same SELECT statement will find the rows faster. It can you the INDEX on "age" and it only has to look at 8.000 rows

Go through all your SQL statements and see if you can execute them faster. And DO not use SQL statements like

SELECT * FROM tbl

不惜一切代价避免对所有列使用"*".仅您需要的列.

关系数据库的十大性能调优技巧 [

Avoid at all cost "*" to all columns. Only the columns you need.

Top 10 performance tuning tips for relational databases[^]

在这里

SQL Server最佳做法 [ SQL SERVER –最佳数据库的15种最佳实践性能 [ ASP.NET最佳做法 [改善ASP.Net Web应用程序性能的最佳做法 [

Here you go

SQL Server Best Practices[^]

SQL SERVER – 15 Best Practices for Better Database Performance[^]

ASP.NET Best Practices[^]

Best Practices to Improve ASP.Net Web Application Performance[^]

这篇关于关于SQL Server驱动程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！