如何使网站快速运作 [英] How to make website work speedily

问题描述

大家好，

我创建了一个用于SPA管理的网站，但是客户端面临的问题是数据加载，这是一个非常缓慢的过程.

我已将Asp.net与c#和MSSQL Server 2008一起用于创建该网站.

我已经使用了每种技术，例如制作存储过程，数据库规范化，使用OOPS概念优化代码，以及在表上建立索引.我也使用过CSS，JAVASCRIPT，AJAX.但是网站仍然太慢了...
而且我的互联网连接也太快了...
但是仍然有太多的数据输入，我需要使其尽可能快.

请帮助我.

该网站的链接为http://jeevaaspa.spaonline.in，请指导我如何使该网站尽快运行.

请务必提供帮助.

谢谢&问候，
Krunal Panchal

解决方案

可以有两种方法:

#1 :需要详细审查体系结构，关键组件设计和代码的关键部分.我简直无法想象您可以在合理的时间内分享所有这些内容并获得审查.我认为这远远超出了CodeProject格式.相反，您可以雇用固定"类型的优秀顾问.

#2 :您可以彻底分析所有代码并获取大量的定时信息，以识别性能瓶颈.我不确定您可以使用标准的探查器对网站代码进行探查(也许我只是不熟悉此类产品)，但是您当然可以构建自己的非常基本的探查器并开始获取计时数据. />
两种方式都非常困难.同时，性能泄漏的原因很容易被新鲜的人​​察觉.再一次，根据您提供的信息说不出其他任何话.

—SA

在数据库端，您可以阅读 SSMS缺少索引功能 [ 解决方案

There can be two approaches:

#1: It needs detailed review of architecture, design of key components and critical parts of the code. I can hardly imagine you can share all this in a reasonable amount of time and get reviewed. I think this is well beyond the CodeProject format. Rather you could hire a good consultant, of the "fixer" type.

#2: You could thoroughly profile all your code and obtain good amount of timing information in order to identify the performance bottlenecks. I''m not sure you can use standard profilers to profile a Web site code (may be I''m just unfamiliar with such products), but your certainly could build your own, very basic profiler and start getting timing data.

Both ways are pretty difficult. At the same time, chances are, the reason of the performance leak can be quite simple and detectable by someone with a fresh eye. Again, it''s impossible to say anything else based on the information you provide.

—SA

From the Database end you could start by reading SQL Tuning Tutorial - Understanding a Database Execution Plan (1)[^] and then search the web for related articles/blogs/tips and read as much as you can.

Also there are potential savings to be made by tuning the indexing. I know that you have set up indexes but sometimes putting an index on an unexpected column (or indeed removing one) can make improvements. With this in mind have a look at SSMS Missing Index Feature[^] and once again do searches on any terms that you are not familiar with.

这篇关于如何使网站快速运作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！