Request to the database (the object it fetches an information (refenced via primary key) to is about 40 tables in total) is very slow (something about 20 seconds lmao).
There is default JPA Repository used to fetch the data from DB.
Do someone know how is possible to optimize a request?
#JPA Hibernate Slow database request
steel trench
waxen waveBOT
<@&1004656351647117403> please have a look, thanks.
ionic coral
Do you know which portion is slow? Getting a connection, the query itself, processing theresponse, ... ?
steel trench
Do you know which portion is slow? Getting a connection, the query itself, proce...
As a basic sql query even with 40+ joins should not be slow, considering that it selects based on already indexed primary keys.
I think that response processing as it should process this object, but it's very huge itself.
E.g., an object with objects where each has more objects and so...
ionic coral
Measure and observe, don't guess.
steel trench
Measure and observe, don't guess.
Huh, there is no way to measure a crud
ionic coral
How so? There are plenty of ways to measure how much time was spent on network traffic, on the database, etc..
steel trench
How so? There are plenty of ways to measure how much time was spent on network t...
I already know that a certain spring jpa repo is slow, comparing with others, because there are no problems in another part of an application with another repos
grand coyote
Increase logging so that you can log the statement plus parameters and do an explain plan later on