The slow SQL execution time is incorrect.

[spinachomes]

I have a database table with only a few dozen rows, and occasionally I encounter slow SQL queries during paginated queries. I checked the io.ebeaninternal.server.query.CQuery source code, and the end time used here is after the query results have been converted into entities, which I think is unreasonable. I believe the end time of the slow SQL query should be immediately after retrieving the ResultSet. I tested the above issue, and the calculation time at retrieving the ResultSet was only 53 milliseconds, while the slow SQL query printed more than 6 seconds.

[spinachomes]

As for why the ResultSet conversion took 6 seconds, I suspect it might be because I called an external service within the entity.

[rbygrave]

So it looks like the application is making a network call in @PostLoad of an entity bean. Correct?

If so, what where the other design options considered instead of doing this in @PostLoad?