@tsteur opened this Issue on January 1st 2020 Member

On every regular request we are now performing an option select query in https://github.com/matomo-org/matomo/blob/3.13.1-b1/core/Archive/ArchiveInvalidator.php#L71 caused by report invalidation in https://github.com/matomo-org/matomo/blob/3.13.1-b1/core/Tracker/Visit.php#L581

This was changed when removing temporary archives in https://github.com/matomo-org/matomo/pull/14639 since every request might now invalidate a previous archive. Before this was only executed when tracking data into a previous day that is not today and therefore rather rare.

Can we maybe use this option like % query use a cache? That would mean though we also need to invalidate the cache when this flag is removed.

Not sure if there is a different alternative.

@mattab marking this for now as a regression since we don't want additional queries like these for each tracking request. Feel free to change it.

@mattab commented on January 8th 2020 Member

@tsteur yes this is a regression.

This Issue was closed on January 8th 2020
Powered by GitHub Issue Mirror