Fedir Zinchuk

I have tested this item :white_check_mark: successfully on e55df52e199481a8fc3cf11085ac2198adfabd1fThis comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/45542.

btw, the query works faster when use filter by category, that is why the frontend does not have the same slow down effect, even though query almost identical.

@richard67 MySQL

I am testing on local Mysql 8.0.32 without any extra configurations. Originally I made installation and all dummy content with joomla 5.2 and then updated to 5.4. With Workflow disabled....

Sure, Without: ```sql SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`state`,`a`.`access`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`ordering`,`a`.`featured`,`a`.`language`,`a`.`hits`,`a`.`publish_up`,`a`.`publish_down`,`a`.`introtext`,`a`.`fulltext`,`a`.`note`,`a`.`images`,`a`.`metakey`,`a`.`metadesc`,`a`.`metadata`,`a`.`version`,`fp`.`featured_up`,`fp`.`featured_down`,`l`.`title` AS `language_title`,`l`.`image` AS `language_image`,`uc`.`name` AS `editor`,`ag`.`title` AS `access_level`,`c`.`title` AS `category_title`,`c`.`created_user_id` AS `category_uid`,`c`.`level` AS `category_level`,`c`.`published` AS `category_published`,`parent`.`title` AS `parent_category_title`,`parent`.`id` AS `parent_category_id`,`parent`.`created_user_id` AS `parent_category_uid`,`parent`.`level` AS `parent_category_level`,`ua`.`name` AS...

My guess, MySQL optimizer have some kind of internal performance rating for its server, and based on this doing its optimization. Or maybe some memory limit config. That can explain...

If we could find which configuration could improve performance with large amount of data, we then probably can skip this hacks, and add "mysql configuration hint" in to joomla manual,...

This is interesting https://stackoverflow.com/questions/50508632/mysql-not-picking-up-the-optimal-index There also a link to how to trace the optimizer https://oysteing.blogspot.com/2016/01/how-to-get-optimizer-trace-for-query.html Here is my trace the query [optimiser-trace.txt](https://github.com/user-attachments/files/20777920/optimiser-trace.txt) But hard to read, for example for index...

@richard67 thanks for looking in to it. > I have started to work on a change to also show articles without workflow association, which would fix some issues, and here...

@richard67 sorry I misunderstood your comment, about "show articles without workflow association", you actually were working on bug :) I thought about removing `workflow` query from the main query, and...