Fedir Zinchuk

Thanks for the PR. Before you continue. We should not change existing integer field. And instead of it, need to create a new Number custom field, which will use NumberField...

This happens because `Access::preloadPermissions()` preloads permissions for ALL 9000 articles (which is around 90MB from your screenshot) https://github.com/joomla/joomla-cms/blob/2d99f3bb4b68688f71f6f915ceb715e51d969e19/libraries/src/Access/Access.php#L269 I set it as bug, however I have no idea how it...

> Any insights or workarounds to alleviate this issue would be greatly appreciated. You can try hack the https://github.com/joomla/joomla-cms/blob/2d99f3bb4b68688f71f6f915ceb715e51d969e19/libraries/src/Access/Access.php#L155 And change ` $preload` to `$preload = false` However it is...

Okay, I think now instead one large DB query you got a few hundrets of small DB queries. That is why it is still slow. Another thing to try is...

After some testing, I think the actual slowdown is somewhere in `‎ArticlesModel::getListQuery()` in the Administrator model https://github.com/joomla/joomla-cms/blob/50726beb7853340ae72458c6479a297988a8fb9e/administrator/components/com_content/src/Model/ArticlesModel.php#L232-L266 it takes a few seconds to load 20 articles from 40k on my...

It sems a few things: - workflow joins, - languages joins, - users joins, When I removing them, everything works much faster.

Ah, it the same as https://github.com/joomla/joomla-cms/issues/43701 I missed it, sorry.

Yea, with LEFT it 0.5s faster, but still slow in total :smile: Hmhm it probably would be much smarter to split it to few queries: load Articles, load language data...

> Kill workflow, problem solved It is not only workflow

Issue with access check hopefully will be fixed in https://github.com/joomla/joomla-cms/pull/44078. I close this issue for now. Thanks for reaport.