Thank you for your response Lukas.
Firstly, the ms was a guess as i didnt run an analyze on the manual query,
but youre right it only runs on about 10ms.
Secondly, we use JooqRecords and use Relations between jooq pojos, not sure
if that matters.
We also quite use the date manipulation (below
Also, is connection pools just added as prop if we use hikari? What are the
ways to know what the correct sizing would be?
Thanks!
Josh
public DataSource dataSource() {
HikariConfig config = new HikariConfig();
config.addDataSourceProperty("cachePrepStmts", "true");
config.addDataSourceProperty(
Edit:
Running explain analyze on this query was 900ms :(
On Monday, February 26, 2024 at 1:25:46 PM UTC+8 Joshua Villano wrote:
Thank you for your response Lukas.
Firstly, the ms was a guess as i didnt run an analyze on the manual query,
but youre right it only runs on about 10ms.
Secondly,