Media Library takes around 8-10 seconds to load

Adding screenshot for single and multiple asset. I do see it just gives around 7-8 assets in result but takes around 2 sec which is still higher in number

Most probably issue introduced because of the AvailabilityPublishingStatusCompare.php.

The AvailabilityPublishingStatusCompare field is calling $this->assetUpdateChecker->checkAssets($values->_entity) for every single row in the media library view during the render() method.

The Problem

N+1 Performance Issue:

• Media library loads: 12 assets per page
• Each asset triggers: checkAssets() call in render()
• Result: 12 individual API calls to Acquia DAM

Why this happens

• The render() method is called for every row when the view is displayed.

Solution

• Remove the "Availability/Publishing status" field from Media library.