在Web应用程序中生成多个报告 [英] Generate Multiple Report in web application

问题描述

Hello Developer，

我创建了一个网页，该网页根据数据库记录和用户选择生成N个报告.它正在生成报告，但问题是

1.与数据库进行交互或由于庞大的/多报表应用程序而挂起直到生成.
2.无法使用多个用户.

那么如何摆脱这个问题呢?或其他任何选项，例如在网页中生成的文件的显示列表后向服务器发送请求或任何其他解决方案，请提供给我.

多亏了所有:)

Hello Developer,

I created a web page that generate N number of report based on Database record & user selection. It is generating a report but problem is

1. While interacting with database or due to huge / Multiple Report application is hanging till generating.
2. Unable to use multiple user.

So how to come out of from this problem? or else any option like post request to server after show list of file generated in web page or any other solution please provide me..


Thanks to all :)

推荐答案

如果我正确理解了您的问题，用户会在用户界面中输入一些数据并点击提交"按钮，这将导致系统请求创建报告(包含大量数据)需要花费很长时间，因此UI会在生成报告时挂起.

第一步是尽可能地优化查询/数据库，经常调优表列上的索引(如果使用SQL，则使用分析器工具)可以解决您的问题.您可以在sql管理器中轻松检查查询的性能

一旦查询尽可能快地运行，请检查您的UI和中间层是否存在代码逻辑中的瓶颈-您可能正在多个地方验证数据等.

如果您的报告仍然很大，则可能需要将其压缩并发送回UI，而不是完整的数据网格等.

如果您的数据非常庞大，则可能需要考虑替换应用程序的工作方式，因此可能需要一个预览报告(例如，UI上显示了100条记录)，以便用户可以确认这是他们期望的结果，并且异步生成完整报告，并压缩报告并将其发送给用户-但是请注意邮件配额.

HTH

If I understand your issue correctly, the user enters some data in the UI and hits a submit button, which causes the system to request the creation of a report (which contains a lot of data) and this takes a long time, so the UI hangs whilst the report is generated.

The first step is to tune your query/database as much as possible, quite often tunning up the indexes on the table columns (use the analyzer tool if using SQL) can resolve your issue. You can easily check the performance of the queries in sql manager

Once you have the queries running as fast as possible, check your UI and middle tiers for any bottle necks in code logic - you may be validating data in multiple places etc.

If you reports are still large, it may be worth zipping them up and sending that back to the UI, rather than a full data grid etc.

If you data is extremely large, you may want to consider replacing the way in which you app works, so maybe a preview report (say 100 records is displayed on the UI) so that they user can confirm that it is what they were expecting and the generating the full report asynchronusly, with the report being zipped and mail to the user - beware of mail quotas though.

HTH

这篇关于在Web应用程序中生成多个报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！