Windows应用程序中的性能改进 [英] Performance improvement in windows application

问题描述

实际上，我们每年都使用Windows应用程序进行员工薪酬审查操作...因为这是庞大的数据驱动应用程序..我们正在使用Windows应用程序....有人可以建议我可以采用任何更好的解决方案来改进性能...如果我们必须迁移到网络...什么是更好的方法...请提出想法....?

Hi,
Actually we were using windows application for our employee compensation review operations which is conducted every year...as this is huge data driven app..we were using windows app....can anybody suggest me any better solution can be implemented to improve performance...and if we have to migrate to web...what is better approach...and ideas please....?

推荐答案

移动到Web应用程序不一定能提高性能.这是因为您引入了额外的数据传输，该数据传输是在浏览器和ASP.NET应用程序之间进行的，ASP.NET从SQL Server获得该数据传输.在Windows应用程序中，您无需进行此数据传输，因为所有数据都已从SQL Server直接加载到客户端.

听起来您真正的性能瓶颈在于您的SQL Server和/或正在使用的查询.如果您不更改其中的任何内容并将应用程序直接移植到ASP.NET，则很可能无法解决性能问题.相反，我建议您开始对数据库和正在执行的查询进行概要分析，以找出使它如此缓慢的原因.

Moving to a web application does not necessarily increase your performance. This is because you introduce an extra data transfer, which is between the browser and the ASP.NET application where ASP.NET gets it from SQL Server. In a Windows application you do not have this data transfer, because all the data is directly loaded to the client from the SQL Server.

It sounds like your real performance bottleneck lies in your SQL Server and/or the queries you are using. If you don''t change anything in those and port the application directly to ASP.NET, you most likely will not resolve your performance issues. Instead I would suggest that you start profiling the database and the queries you are executing to find out what is making it so slow.

迁移到Web更好，
为此，好的技术是ASP.net，C#，最好的数据库是SQL Server

Migrating to web is very much better,

for this the good technologies are ASP.net,C# and the best database is SQL server

这篇关于Windows应用程序中的性能改进的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！