[MacPorts] #63722: ports.macports.org: page refreshes for "maintained by me" and "watched by me" now incredibly slow

[MacPorts]

#63722: ports.macports.org: page refreshes for "maintained by me" and "watched by
me" now incredibly slow
---------------------+-------------------------
 Reporter:  mascguy  |      Owner:  arjunsalyan
     Type:  defect   |     Status:  assigned
 Priority:  Normal   |  Milestone:
Component:  website  |    Version:
 Keywords:           |       Port:
---------------------+-------------------------
 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 15+ 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

-- 
Ticket URL: <https://trac.macports.org/ticket/63722>
MacPorts <https://www.macports.org/>
Ports system for macOS