Ben Davies
Ben Davies
> I don't believe I can add this to the mapped entity in the bundle but can document this for I think you can probably l isten to `postGenerateSchema` and...
> So an index w/o `setUseOutputWalkers(false)` doesn't improve performance? It does not. It speeds up the inner select of the previous query, but the `MIN(sclr_16) AS dctrn_minrownum` and `GROUP BY...
no that doesn't work as the templates use methods in the entities.
> So is this slowness only on the dashboard - not on /history? yes, history as well, actually. but it doesn't look like i can apply my fix as easily...
yes because disable fetch joins will also stop the paginator rewriting the query https://github.com/doctrine/orm/blob/3.3.x/src/Tools/Pagination/Paginator.php#L115
we always want to disable `fetchJoinCollection` in this bundle as `ProcessedMessages` has no relations
that won't fix history will it?
you are right, it does fix it, and you are correct again, there are other slow queries on the history page
```sql SELECT COUNT(p0_.finished_at) AS sclr_0 FROM processed_messages p0_ WHERE p0_.failure_type IS NULL LIMIT 1 SELECT COUNT(p0_.finished_at) AS sclr_0 FROM processed_messages p0_ WHERE p0_.failure_type IS NOT NULL LIMIT 1 ``` these...
```sql SELECT AVG(p0_.wait_time) AS sclr_0 FROM processed_messages p0_ LIMIT 1; SELECT AVG(p0_.handle_time) AS sclr_0 FROM processed_messages p0_ LIMIT 1; ``` cannot be sped up. a better way to do with...