Improve Adaptive Media counter performance

• Type: Story
• Status: Open
• Resolution: Unresolved
• Affects Version/s: 7.0.X, 7.1.X, Master
• Fix Version/s: None
• Component/s: Adaptive Media
• Labels:
  • 7.2-could
  • 7.3-known-issues
  • 7.4-known-issues
  • INACTIVE
  • ee-ts
  • liferay-ga2-ce-741
  • liferay-ga4-ce-733
  • liferay-ga5-ce-734
  • liferay-ga6-ce-735
  • liferay-ga7-ce-736
  • liferay-ga8-ce-737
• Flagged:
  Impediment

Currently counters implementing com.liferay.adaptive.media.image.counter.AMImageCounter for Adaptive Media are retrieving on demand the total of images to adapt with different dynamic queries over the DLFileEntry table.

This kind of queries are producing a poor performance when there are a huge quantity of files, for example 2'5 millions

As a result the UI is not responding and getting 502 errors when you access to Control Panel > Adaptive Media