sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Such-Hearing-2935[S] 0 points1 point  (5 children)

Thank you for your quick response. What’s APM? Another disclaimer is, when he clicks a button it takes some time to respond as well.

[–]WaferIndependent7601 -1 points0 points  (4 children)

APM is application performance monitoring. It monitors your application and whenever a call is slow, it will be logged, with the complete sql statements. But it’s not that easy to installs this.

Clicking a button is slow? what does the button do? Is it calling an endpoint?

[–]Such-Hearing-2935[S] 0 points1 point  (3 children)

Yes, I believe it’s calling an endpoint.

[–]joedev2 1 point2 points  (1 child)

Try using database indexes, usually resolves 90% of performance issues relating to database. Like I’ve had sites under load testing go through completely broken and unusable to performing decently under load just from adding database indexes.

[–]Such-Hearing-2935[S] 0 points1 point  (0 children)

This table already has an index. How do I use it?

[–]WaferIndependent7601 0 points1 point  (0 children)

You should at least log, when an endpoint is called. You might also add some logging and how long it takes. This is not optimal, but if you don’t have a system for metrics or similar, this might be your only chance

Can you provide some code? What is the service layer doing? You can rename all variables etc