[MacPorts] #70556: "base" seemingly locking up for sometimes very long

[MacPorts]

#70556: "base" seemingly locking up for sometimes very long
--------------------------+--------------------
  Reporter:  RJVB         |      Owner:  (none)
      Type:  enhancement  |     Status:  new
  Priority:  Normal       |  Milestone:
 Component:  base         |    Version:
Resolution:               |   Keywords:
      Port:               |
--------------------------+--------------------

Comment (by RJVB):

 Replying to [comment:21 neverpanic]:

 Apart from observing that I clearly have a less exclusive idea of the
 principle of entraide (which I may need to reconsider as far as MacPorts
 is concerned) I'm going to ignore this bunch of vitriol.

 However, `macports.sqlext` seems to be outdated or otherwise ineffective
 with current sqlite versions or the instructions how to use it are
 incomplete. I have the version from the macports repo (master branch of a
 few weeks old) built and installed and just loading it changes nothing.

 I will point out this though:
 - the brunt of the user base will probably accept slowness of certain
 operations as normal, prefer to create a fresh install of the few things
 they need after upgrading their OS rather than following complicated
 upgrading instructions ... or have moved to HB long since
 - I am not going to be convinced easily that anyone who did end up with a
 decades-old registry of several Gbs on a current OS version is going to be
 unaffected by any of the symptomes described above.
 - Until just now I wouldn't have believed that anyone with any amount of
 heart for the code s/he wrote would not have been incited to ask
 themselves if there were not some way to optimise the registry database
 for instance by determining an optimal pagesize.

 From what I understand there is 1 (ONE) frickin parameter that can be
 tweaked and that is likely to have an impact on performance.

 How much time could it take to indicate how to change that parameter
 safely?!

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