Feature #28902

Configurable ACCESS_TIME precision

Added by Markus Blaschke almost 2 years ago. Updated 10 months ago.

Status:Accepted Start date:2011-08-10
Priority:Should have Due date:
Assignee:- % Done:

0%
Category:-
Target version:-
TYPO3 Version:4.7 Complexity:medium
PHP Version:5.3
Votes: 0

Description

Make the precision of $ACCESS_TIME configurable for better query_cache efficiency.

eg. in t3lib/config_default.php:

// default
$TYPO3_CONF_VARS['SYS']['ACCESS_TIME_PRECISION'] = 60;

[...]

$ACCESS_TIME = $EXEC_TIME - ($EXEC_TIME % $TYPO3_CONF_VARS['SYS']['ACCESS_TIME_PRECISION']);

would be nice to see this feature in 4.5 tree.

History

#1
Updated by Susanne Moog almost 2 years ago

Could you explain a bit more about why this would help and where you see the current problems?

#2
Updated by Georg Ringer almost 2 years ago

mysql cache doesn't like a new query per secone too much because of enable fields. so with this setting it can cache it for a certain period

#3
Updated by Markus Blaschke almost 2 years ago

In our most installations a precision in days would do it - mysql could cache each query for a whole day not only for one minute.

#4
Updated by Susanne Moog almost 2 years ago

  • Status changed from New to Accepted
  • TYPO3 Version changed from 4.5 to 4.7
  • Complexity set to easy

Ah, sounds good. As it's a feature it can only go to 4.7 (we already have feature freeze for 4.6) - but maybe the release managers of 4.6 and for 4.5 allow it as a performance fix?

#5
Updated by Oliver Hader almost 2 years ago

I guest that ACCESS_TIME is not only used for caching in TYPO3.
Concerning caching I'd prefer to have a new setting/value here - has to be analyzed...

#6
Updated by Oliver Hader almost 2 years ago

  • Complexity changed from easy to medium

#7
Updated by Ernesto Baschny over 1 year ago

Currently we have (in config_default.php):

$ACCESS_TIME = $EXEC_TIME - ($EXEC_TIME % 60);

This is used in the enableFields query, for example, so that those won't generate a new query each second, but keep the same query for the same minute: So that MySQL can use the query-cache and we still having the feature of being able to publish content on a certain minute.

The change was introduced back in 2008 for 4.1:

http://git.typo3.org/TYPO3v4/Core.git?a=commitdiff;h=fd5a82be213c2d779f2383c9469438b1083f7169

Having the precision configurable could be a performance beneficiary option, but will probably only be tuned by very specific sites where the query cache is an issue. It remains proven if tweaking this will really give some real world benefit.

So I would opt for adding this feature in 4.7 and have it proven in the world. It will then be part of the next LTS of course. If it proves so useful by then, we can think about backporting it to 4.5, of course.

#8
Updated by Markus Blaschke over 1 year ago

Sounds good, thanks.

#9
Updated by Markus Blaschke 10 months ago

Is there any progress on this issue?

Also available in: Atom PDF