use tptp to monitor java application performance (1)

最新推荐文章于 2025-12-26 18:13:00 发布

原创最新推荐文章于 2025-12-26 18:13:00 发布 · 705 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#performance #TPTP #java

JAVA 专栏收录该内容

8 篇文章

订阅专栏

文章探讨了使用Oracle执行查询时遇到的性能问题，以及TPTP工具在实际应用中表现的随机性和不稳定特性。通过案例分析，揭示了Oracle内部执行查询耗时的原因，并指出TPTP工具可能存在的局限性，特别是对于远程调用的处理。最后，文章得出结论，某些情况下，TPTP工具可能导致性能评估失真。

Use TPTP monitor. Sometime TPTP says it is slow, but real case is it is not slow. Why?

See the following picture

getSaeSarEodByPtfl() only query database, but uses 0.28s, It is too slow? You want tune it? No, the root cause is from Oracle executeQuery(), it costs 0.26s. So your code, cost 0.02s, it is acceptable.

But why Oracle use 0.26s? It is network cost?, no, in real time(no tptp) the whole http request only 0.087s. So we think TPTP make it slow?

I don't know!!!!

I click 11 times, I found some time it is fast, see picture, "Min Time" is 0.07s and 0.05s.

So what is conclusion? TPTP make it slow,and random. Some time it is normal, some time it is slow. What TPTP has done? Maybe TPTP is not a stable tools. Ot TPTP has limitation. It suite for "calculation in memory, but not remote call"

Not see the absoluted value, but relative value. Two cases will show getSaeEodSarByPtfl()-Oracle time=0.02s. So getSaeEodSarByPtfl() no need to tune.