如何使用MSSQL Server提高asp.net应用程序中插入，删除，搜索和执行的速度 [英] how to increase the speed of insertion,deletion ,search and execution in asp .net application with MSSQL Server
问题描述
嗨亲爱的
可以告诉我如何提高ASP .net网站应用程序的速度。
我已经建立了一个以Microsoft SQL服务器作为后端的ASP .Net网站。我的数据库表中有数百万条记录。因此它使条件插入，搜索和删除非常慢。我已经在所有表中应用了索引。我正在使用存储过程...在我的存储过程中有一些复杂的计算。计算是用于插入和从表中获取数据。但是我的执行速度非常慢。这里数据从Excel工作表插入表格。
请告诉我如何快速申请我的申请....
谢谢大家....
Hi Dears
could any one please tell me how to increase the speed of my ASP .net web site application.
I have made an ASP .Net web site with Microsoft SQL server as back end.There are millions of records in my Database tables. So it makes the conditional insertion , Search and deletion very slow. I have applied indexing in all tables.I am using stored procedures...there are some complex calculations in my stored procedures.The calculation is for inserting and fetching the data to and from the tables.Still I am getting very slow execution.Here data is inserting from an excel sheet to the tables.
Please tell me how to make my application very fast....
Thank you all....
推荐答案
您使用的是高效的服务器吗？您是否为应用程序和数据库使用单独的服务器/核心？什么是硬盘的RPM？存储驱动器的最大数据传输速度是多少？正在使用GBPS网络？什么是RAM大小和时钟速度？
很多时候我们只是在不计算所需资源的情况下部署软件。速度是有效的软件和硬件组件的组合。
Are you using efficient servers? Are you using separate servers/cores for Application & Database? What is the RPM of hard disk? What is the maximum data transfer speed for storage drive? Are using GBPS network? What is the RAM size and clock speed?
Many times it happens that we just deploy the software without calculating required resources. The speed is a combination of effective software and hardware components.
改善一切 新
快速解决方案可以是进行表分区和归档，以减少表中的行数。检查此链接。
了解分区 [ ^ ]
A quick solution could be to do table partitioning and archiving to reduce the no of rows in the table. Check this link.
Understanding Partitioning[^]
这篇关于如何使用MSSQL Server提高asp.net应用程序中插入，删除，搜索和执行的速度的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
