Queries assets optimization Please help.

Discussion regarding Joomla! 3.x Performance issues.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Post Reply
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Sat Nov 24, 2018 3:22 am

Queries assets optimization Please help.

Post by stuarty2k » Sat Nov 24, 2018 3:31 am

Can someone help me with query optimization? Apparently I have about 30 queries that make my page slow but it seems that this is one of the worst and has to do directly with the core of Joomla, the assets are very slow. Maybe I can index a table or something to reduce the time.

Reading mysql slow query log from /var/log/mysql/mysql-slow.log
Count: 466 Time=0.01s (2s) Lock=0.00s (0s) Rows=10247.0 (4775085), mydb[mydb]@localhost
SELECT `id`,`name`,`rules`,`parent_id`
FROM `mykch_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

Post Reply

Return to “Performance - Joomla! 3.x”