"My caches" page generation performance ?

[andrixnet]

I was just playing around my OC account today when I noticed something a bit odd. Might have happened at other times but this is when I took notice.

Most OC pages load almost instantly (on OCRO).
Searches are fast. Cache page loads fast. Small fraction of a second.

"My caches" page takes between 1 and 2 seconds to load. Clearly it is working a log more to process generating the page.
All tabs on "My caches" behave this way. Navigate pages by number behaves the same.
Note: I have 400+ caches in my account.

[stefopl]

I won’t be available for the next week or two, but if you'd like to investigate the performance issue further in the meantime, here's a suggestion:

You can use the StopWatch utility to measure which part of the mycaches.php script is taking the most time.

To enable it, add the following line near the top of mycaches.php
use src\Utils\Debug\StopWatch;
, just after:
require_once __DIR__ . '/lib/common.inc.php';
Add:
StopWatch::click('start');
Then at the very end of the script, add:
StopWatch::click(__LINE__);
StopWatch::displayResults();

You can also add intermediate measurements to narrow down the slowest parts, like this:
StopWatch::click(__LINE__);
Add at logical midpoints or suspected slow blocks (loops, DB queries, etc.)

For better readability, you can replace __LINE__ with a custom label,
StopWatch::click('before_something');
StopWatch::click('after_something');

Once you've added these, you can access the results by visiting:
mycaches.php?StopWatch

Preferably do this on a development or local environment. If you do test this on production, please remember to revert any manual changes afterward to avoid conflicts during auto-deploy from Git.