Not optimal query in DatabaseBackend::garbageCollection()

Created on 29 March 2023, almost 2 years ago

Problem/Motivation

Range in select query allows getting multiple rows when only one is needed.

->range($this->maxRows, $this->maxRows + 1) in DatabaseBackend::garbageCollection()

As result, it can cause performance problems when database_cache_max_rows is high.

πŸ› Bug report
Status

Fixed

Version

9.5

Component
CacheΒ  β†’

Last updated about 15 hours ago

Created by

πŸ‡ΊπŸ‡¦Ukraine mostepaniukvm

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Production build 0.71.5 2024