Performance improvements

[bwaidelich]

This issue should serve as an epic for performance related improvements for Neos 9.0

• inline editing - Reduce number of NodePropertiesWereSet events during inline editing #4387
  • Currently when inline-editing a text in the Neos content module, changes are sent to the server during typing leading to sometimes multiple NodePropertiesWereSet properties per second!
• Flow Query - FlowQuery add limit to find operation to improve performance (and dont slice in php) #4205
  • Especially the find operation is really slow currently because a CTE has to go through all nodes
• Rework CatchUp mechanism - Rework CatchUp mechanism #4746
• Don't rebase the user workspace on Login if not required Don't rebase the user workspace on Login if not required #4728
• Implement subgraph with runtime caches correctly
  • TASK: Find node by path runtime cache #4763
• ES CR DBAL Adapter FEATURE: Performance improvements for ES CR DBAL Adapter  #4818
• Potential performance improvement: "Fast forward content streams" #5264
• Potential performance improvement: Turn partial publish into full publish if outcome is the same #5303

[mhsdesign]

Also our ContentSubgraphWithRuntimeCaches can be improved a lot as it mostly doenst cache or read from the cache.

I found a tiny improvement here already: neos/contentrepository-development-collection#129