Hi , I'm facing performance issue with select count(*) with some conditions on a table of more than 1 billion records. My code looks like this : ResultQuery<?> query = dslContext.selectCount().from(Tables.TEST).where(conditions) Integer retVal = dslContext.fetchOne(query).into(Integer.class);
The conditions list contains 4 conditions : date range and simple comparison condition on 3 other fields. if date range = 1 month and the total hit records count about 80000 records, it will take about 1 minutes - 2 minutes to get result. If date range = 1 month, it will take about 5 mins - 10 mins Do you have any idea on how to improve performance in this case. Appreciate if anyone can help. Thanks -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/124c1a3c-3594-4d9c-bf43-91e59e0bd4e8n%40googlegroups.com.
