多次调用导致的大数据库响应时间。 [英] Large DB Response Time due to multiple calls.

问题描述

您好，

我们有一个银行应用程序，包括前端的ASP.NET和后端的Oracle DB，它们经常会遇到很大的延迟。我是监控团队的一员，在我的调查中，我观察到由GetValues和Oralce.DataAccess.Client.OralceDataReader类中的Read方法进行的超过1500次调用超过15秒，这导致了这种延迟。看起来这可能是因为应用程序试图检索多行数据。



开发人员不知道如何解决这个问题。如何解决此问题并提高性能？我们如何以不同的方式编码以减少数据库的调用次数和/或响应时间？

Hello,
We have a banking application consisting of ASP.NET in the front end and Oracle DB in the backend that constantly experiences huge delays. I'm part of the monitoring team and in my investigation, I observed over 1500 calls being made by the GetValues and the Read methods inside the Oralce.DataAccess.Client.OralceDataReader class taking over 15 seconds which is contributing to this delay. It seems that this might be because the application is trying to retrieve multiple rows of data.

The developers don't know how to fix this. How do I address this issue and improve performance? How can we code differently in order to reduce the number of calls and/or the response time taken by the DB?

推荐答案

在oracle服务器上运行一个探查器并添加或者根据剖析器结果删除索引。



如果没有看到你的系统在运行，很少有人可以帮助你。

Run a profiler on your oracle server and add or remove indexes based on the results of the profiler findings.

There is very little anyone can help you more without seeing your system in action.

这篇关于多次调用导致的大数据库响应时间。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！