search

mokhin-denis / mod_myanniversary

MyAnniversary module for Joomla CMS. Module shows you anniversaries of current day
https://mokhin-tech.ru/en/myanniversary
0 stars 0 forks source link

MySQL query performance #1

Open esedic opened 8 years ago

esedic commented 8 years ago

I have a large news site with 200.000+ articles and after installing and configuring mod_myanniversary my site became really slow. After debugging MySQL queries on my Joomla site I discovered that query from mod_myanniversary is taking a lot of time to execute:

vzmd_debug

I'm querying 5 categories. If I disable module, page load is normal again. I don't know much about MySQL, but could it be that the problem is that CONCAT can't use index and will perform full-table scan?

mokhin-denis commented 8 years ago

You are the first one with so large site! Dont know, what to tell you about it. We can try to fix it together

esedic commented 8 years ago

I discovered that if I use only 1 category, performance is normal. When there are at least two, problems start.