[wp-trac] [WordPress Trac] #54221: _transient_dirsize_cache is set to autoload=yes and kills db performance if it grows (20MB in our case)
WordPress Trac
noreply at wordpress.org
Wed Oct 6 14:56:26 UTC 2021
#54221: _transient_dirsize_cache is set to autoload=yes and kills db performance if
it grows (20MB in our case)
--------------------------+-------------------------------------
Reporter: archon810 | Owner: (none)
Type: defect (bug) | Status: new
Priority: normal | Milestone: Awaiting Review
Component: Database | Version: 2.8
Severity: major | Resolution:
Keywords: | Focuses: multisite, performance
--------------------------+-------------------------------------
Comment (by SergeyBiryukov):
Replying to [comment:6 iandunn]:
> Instead of calculating the size synchronously (but with the data
partially cached), we could do a full calculation '''asynchronously''',
and cache the result. That way the user always sees cached data, which is
faster and avoids storing megabytes of data in an option.
That sounds like a good approach.
--
Ticket URL: <https://core.trac.wordpress.org/ticket/54221#comment:7>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform
More information about the wp-trac
mailing list