-
|
select count(*) as aggregate from it slows down our application a lot, cpu is > 100% all the time, we have many tables with 1-3M records... what can we do? |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment 2 replies
-
|
I would suggest looking at indexing, Kai Sassnowski made a good talk at Laracon covering this subject. |
Beta Was this translation helpful? Give feedback.
-
|
The same problem. Database has indexing. Only query "count as aggregate" is very slowly...
|
Beta Was this translation helpful? Give feedback.
-
|
Seem like query subselect would be a better choice instead of join. https://laravel-news.com/eloquent-subquery-enhancements |
Beta Was this translation helpful? Give feedback.
I would suggest looking at indexing, Kai Sassnowski made a good talk at Laracon covering this subject.
https://www.youtube.com/watch?v=HubezKbFL7E