Feeling Lucky
No Code Attached Yet
[#32995] - [4] Post Install Actions for totp run useless sql on every page load
- Closed
- 7 Mar 2022
- Medium
- Build: staging
- # 32995
Steps to reproduce the issue
Joomla 4.0-dev
enable debug mode
Visit any admin console page and view the queries run in the debug toolbar
Expected result
Caching so that a useless query is not run on every page load
Actual result
SQL is run on every page load, that by default, actually returns ZERO rows (as 2fa is disabled by default)
SELECT *
FROM `jos_extensions`
WHERE `type` = 'plugin' AND `enabled` = 1 AND `folder` = 'twofactorauth'
System information (as much as possible)
Additional comments
joomla-cms-bot
- | Labels |
Added:
?
|
||
PhilETaylor
- comment
- 25 Apr 2021
Fixing this is not as easy as first thought...
| Status | New | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2022-03-07 18:38:24 |
| Closed_By | ⇒ | PhilETaylor | |
| Labels |
Added:
No Code Attached Yet
Removed: ? |
||
so today I (re-)learned that Joomla doesn't have a caching layer that's of use, unless "caching" is enabled in global config... this sucks, (what I'll call) object caching for things like this should be "a thing" so that we can speed up joomla and stop making Joomla recalculate things on each page load - especially when nothing has changed. These internal caches should not be connected/related to the caching layer for the frontend.