ports.macports.org: page refreshes for "maintained by me" and "watched by me" now incredibly slow

[mascguy (Christopher Nielsen)]

Per recent discussion on the dev mailing list, page refreshes for areas "Maintained by Me" and "Watched by Me," which used to refresh near-instantly, are now painfully slow: These routinely take up to 30 seconds to refresh, which is an eternity relative to the previous behavior.

Initially the thought was that perhaps this was due to the backlog of updates - there was four days' worth - and/or site warmup. But a few days later, things haven't improved whatsoever.

It almost looks as if the database used as the backing store, is now lacking an index. Or perhaps the index needs to be rebuilt, to handle the expanded port name limits?

Regardless, this needs to be fixed.

Link to the mailing list discussion:

​https://lists.macports.org/pipermail/macports-dev/2021-October/043830.html

[mascguy (Christopher Nielsen)]

Interestingly enough, if I use the REST API to pull the equivalent set of ports as "Maintained by Me," the response is returned very quickly - within one or two seconds.

So it doesn't appear to be an issue with the database after all. The question is, what is the page doing now, given that the API is still incredibly responsive?

[mascguy (Christopher Nielsen)]

Just timed a page refresh, with Firefox Dev Tools enabled. It now takes up to 30 (!!!) seconds.

Updated ticket description to match.

[arjunsalyan (Arjun Salyan)]

Oh, it was very very slow! Turns out it was indeed a database issue and VACUUM ANALYZE seems to have brought back performance back to lightning fast for this particular page. Can you please confirm and update the ticket accordingly?

Thanks for reporting and helping keep the website running smooth.

[mascguy (Christopher Nielsen)]

Looks great now. Thanks for the quick fix Arjun!