如何在Web应用程序中提高SQL数据库中报表加载数据的性能 [英] How to imporve performance of report loading data from SQL database in web application

问题描述

----问题开始--------

如果您的Web应用程序中有报告，那么您正在从SQL SERVER db向此报告加载数据，此报告是有一些性能问题，如永远加载，影响整个网站。



您将采取哪些步骤来解决缓慢问题并尽快加载报告。< br $>
-----问题结束--------





---- - 进一步解释---

我在几次采访中被问过上面的问题，我根据自己的知识和经验回答了这个问题。但我认为这并没有给面试官留下深刻印象。这是一个非常重要的问题..



因此，根据您的实践经验，专业知识和工作知识，我想知道这个问题的答案。



我不想在谷歌上搜索这个问题，因为根据我的知识，我知道答案的一部分。但是我想知道他们是否对这个问题有改进的余地。



所以，我会很感激基于你的专业知识和个人经验的答案，而不是发布一些谷歌链接。



提前致谢

---- QUESTION START --------
If you have a report in your web application, your are loading data to this report from SQL SERVER db and this report is having performance issues like taking forever to load, affecting entire website.

What steps you would take to resolve the slowness issue and make the report load as quickly as possible.
----- QUESTION ENDS --------


----- FURTHER EXPLANATION ---
I have been asked above question in several interviewS, I answered this question as per my knowledge and experience. but I think it did not impress interviewer. Its a very IMPORTANT question..

Hence I would like to know answer of this question as per your PRACTICAL EXPERIENCE, EXPERTISE and WORK KNOWLEDGE.

I don't want to search this question on google, because I know part of answer based upon my knowledge. But I want to see if their is a room of improvement for this question.

So, I would appreciate answers based upon your expertise and personal experience rather than posting some google links.

Thanks in advance

推荐答案

选项1.确保您的报告仅返回您的数据要求，而不是所有数据......即：让SQL Server通过在存储过程中适当使用where子句/参数来选择正确的数据。



选项2如果报告本身需要大量数据，并且数据可以稍微过时，请使用复制数据库，使用副本生成大量报告（这样您就不会使用主服务器） 。



选项3.将SQL Server和IIS放在不同的物理计算机上...在SQL Server上运行报表的一个用户不应该影响每个用户你的网络系统......

Option 1. Ensure your report is only returning the data you require, not all data... ie: let SQL Server select the correct data through the appropriate use of a where clause/parameters in the stored procedure.

Option 2. If the report itself requires a massive amount of data, and that data can afford to be slightly out of date, have a replicated database, using the replica to generate your huge report on (so that you aren't using the main server).

Option 3. Have your SQL Server and your IIS on a different physical machine... One user running a report on SQL Server shouldn't affect every user of your web system...

这篇关于如何在Web应用程序中提高SQL数据库中报表加载数据的性能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！