Site speed is particularly slow

Created 6 years ago by spotony

select * from `applications` left join `applications_domains` on `applications`.`id` = `applications_domains`.`application_id` where `applications`.`domain` = 'www.eme100.com' or `applications_domains`.`domain` = 'www.eme100.com' limit 1
2.15ms
em_system
select * from `em_settings_settings`.  2.2ms

This two-day database query statement led to the site speed is very slow, ask what reason?

ryanthompson — 6 years ago

Is it doing that every time? It should be caching that result. Are you up to date?

Link

spotony — 6 years ago

@ryanthompson Yes, this is up to date. How to cache these two data? Please advise! Thank

Link

ryanthompson — 6 years ago

I can push a patch to cache settings model. And .. applications I suppose could be cached as well. I'll handle it for ya.

Link

ryanthompson — 6 years ago

I just updated preferences and settings module to both cache. More to come 😊

Link