[#15772] - [4.0] [RFC] Remove per second publish_up/publish_down times
- Closed
- 10 Apr 2018
- Medium
- Build: staging
- # 15772
Lets try this one last time...
In order for mysql caching to be most performant, the queries need to be exactly the same
At the moment each query with a publish_up/publish_down time in it has a second part to the time
This means that mysql cannot cache the query.
Suggestions include (over the years)
-
Remove the seconds - meaning mysql can only cache for a minute
-
Allow this to be configurable, either use just days or hours or mins or second based timestamps in the SQL queries (always allowing the full datetime to be stored when saving the articles)
-
answers on a postcard please...
Joomla 4 is a great time to revisit this... making Joomla more performant and breaking with b/c
joomla-cms-bot
- | Labels |
Added:
?
|
||
franz-wohlkoenig
- | Category | ⇒ | com_cache Feature Request SQL |
| Status | New | ⇒ | Information Required |
| Title |
|
||||||
| Status | Information Required | ⇒ | Discussion |
| Status | Discussion | ⇒ | New |
| Status | New | ⇒ | Discussion |
| Labels |
Added:
J4 Issue
|
||
| Labels |
Added:
?
|
||
| Status | Discussion | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2018-04-10 13:37:43 |
| Closed_By | ⇒ | brianteeman |
Just like the same that happened at every major series since the start... its a shame, because this one change would make Joomla content a lot more performance and cacheable.
If I had time I'd take it. But, well, prepared statements aren't going to write themselves.
I could not see the point in doing any code until it at least had some interest here.. which apparently it doesnt :(
@PhilETaylor if its so important to you then PR is welcome and I will personally ensure that it gets tested promptly. Unfortunately with issues like this many people wait to see code as they can not visualise the issue or they do not have the development skills to appreciate the issue
Sorry but as there has been no interest by anyone in moving forward with this feature request I am going to close it,