I need to measure the query execution time, how can I do this?

[NikitPA]

Hi, I need to measure the query execution time, how can I do this? The library itself has a "MessageProcessingTime - Average time of processing message" metric, but this is not what is needed, since this metric shows up to the time when we take our request from the queue of requests, and I need the time for full processing.

[nhanth87]

you can add timeA and timeB to your code during process message?
what's the problem?
checking execute time at application layer is better than doing it in framework

[NikitPA]

@nhanth87 The problem is that this time will be my processing, my methods. But the total time is important to me, since a request can wait in the queue for a long time before one of the worker threads takes it for processing.

[nhanth87]

the process of every diameter message is under < 0,0001 sec. We have tested for 10000 tps
in the case you put in queue, queue is also support processing time (rabbit, kakka...)

[NikitPA]

You're talking about testing, but you didn't say anything about which CPU and Memory resources this testing was running on. I tested on two CPUs, and only output to the log what came (my logic) and the server could withstand 1500 rps. In this case, if 50,000 requests per second arrive on the server, the queue will fill up, and my logic will have the same processing time, so I want to get the full request processing time.

[nhanth87]

for those data, you need to buy
1500 tps is joking, really funny
in the case you require 50k tps, please contact with mobius or paicbd

[NikitPA]

And how can you claim that you tested for 10,000 and everything was fine if you didn't say what you tested on, what resources? The application configuration sets , and the more CPU there is, the more threads are actually running, the more we can set this number and the more we will subtract messages from the queue.

[nhanth87]

I let you know that mobicent is dead, telestax is dead
If you want professional support then contact mobius and paicbd. They are all certificated parter of telestax and some telestax members are working there.

I didn't work in this for a longtime and switch to other domain so those are all my suggestion
If you want free support then go to other project

[NikitPA]

"If you want free support then go to other project" - What kind of project are we talking about? I haven't found any alternatives, can you tell me?

[nhanth87]

currently the most used is freeDiameter https://github.com/open5gs/freeDiameter
I also used it for some viettel project
btw, you need to lear C to use it

[kaustubhDsarathi]

You can also give this a try: https://github.com/quarkiverse/quarkus-jdiameter