Mini Fronto Page many articles

Hi Marco, 
I tried installing the default Joomla Articles module (mod_articles), and I found that even the joomla built-in module takes a long time to render. See image below



So, I assume this is more likely a Joomla issue rather than a problem with the module itself.

Minifrontpage Pro is built based on the standard Joomla mod_articles, so both use the standard Joomla model ContentModelArticles. After doing some research, I found that ContentModelArticles must build a large query against the #__content table on every request. While the LIMIT parameter restricts the final result, MySQL still has to scan and sort through many rows (based on state, publish_up/down, language, access level, featured status, and ordering) before it can apply the LIMIT.

At this point, the only practical solution is to enable caching. If you prefer not to use cache, you could try increasing the server RAM/resources
Another option is to enable caching and then clear the cache every time you post an article, you can use a plugin like Cache Cleaner to automate that.

However, for a website of this size, I think enabling Joomla’s cache is highly recommended and almost essential.

Yes! Indexing the database was one of the ideas that came to my mind to improve, but I couldn’t implement it earlier because it would be too hacky and customized. However, for a website as large as yours, such a special treatment does make sense.

Still, it’s quite surprising that even after you performed the indexing, it didn’t work.

Using a direct query as suggested could indeed be a possible solution, but it’s quite risky because Joomla’s ArticlesModel handles a lot of complex logic (multi-level ACL, user groups, multilingual fallback, tags, etc )
Without using the model, you’d have to manually replicate all of that, and missing any part could lead to unintended results, such as displaying restricted articles or breaking certain features.

That said, if your case doesn’t require access checks, multilingual handling, and other advanced logic, creating a custom version of MiniFrontpage Pro could indeed be a viable solution.

Marco can you please re-enable the temporary admin login? I'd like to test using custom query instead of using the joomla article model