响应时间减慢到多个用户的爬行速度 [英] Response time slows to a crawl with mutiple users

问题描述

我有一个BE / FE应用程序，BE在网络服务器上。该应用程序有一个未绑定的数据输入表单，当用户保存记录时，它会进行一些验证，然后更新大约155K记录的原始数据表，并更新几个
小的统计表，这些表会增加汇总数据。摘要表绑定到交换机。原始表有一个PK和2个唯一键。

当一个用户打开时，加载时间大约为0.9秒，节省时间大约为1.5秒。但是，当用户＃2登录时，每次加载时间最长为5.5秒，每次保存时间为22秒。用户＃2甚至不在数据输入应用程序中，只有
交换机。

我应该注意什么？以减少多个用户的响应时间？

---

Darrell H Burns

解决方案

你是否保持与后面的持久连接末端？

I have a BE/FE application, with the BE on a networked server. The app has an unbound data entry form that when the user Saves a record, it does some validation, then updates a raw data table of about 155K records, and also updates a couple of small statistical tables that increment summary data. The summary tables are bound to the switchboard. The raw table has a PK and 2 unique keys.

When one user is on, the Load time is on the order of 0.9 seconds, and the Save time about 1.5 seconds. However, when User #2 is logged in, the times shoot up to 5.5 seconds per load, and 22 seconds per Save. User #2 is not even in the data entry app, only the switchboard.

What should I be looking at to reduce the response time when there are multiple users?

---

Darrell H Burns

解决方案

Do you maintain a persistent connection to the back-end?

这篇关于响应时间减慢到多个用户的爬行速度的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！