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.
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.