[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:
Resolution:           |   Keywords:
      Port:           |
----------------------+-------------------------

Old description:

> 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

New description:

 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

--

Comment (by mascguy):

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

 Updated ticket description to match.

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