[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:19 neverpanic]:

 > - If you're on old macOS versions, you're likely also using a very
 outdated copy of SQLite, since MacPorts uses the OS copy. Chances are a
 newer SQLite might be faster.

 Note that @barracuda156 is at the current MP version with its own sqlite3
 copy. While newer versions might be faster chances are that you'll only
 benefit optimally from those performance improvements with a new database.

 > Finally, a note on ticket hygiene: Please don't randomly Cc me to ticket
 you file because you believe I should do anything about your issue. I'm
 doing this in my free time, I have no obligation whatsoever to solve a
 problem you seem to have, nor do I provide any guarantees on MacPorts'
 performance on your particular machines.

 There was none of that. You were CC'ed because the commit log suggests
 that you're among the few core devs who are familiar with the registry
 design, who could explain what kind of DB tweaks could be tried safely,
 what kind of customisation was performed on the registry database that
 "stock" sqlite3 doesn't want to modify it and how to work around that,
 etc.

 I'm probably also one of the select very few who observe that the
 community "entraide" spirit has largely disappeared around here...

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