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-ga1-dxp-7413
  • liferay-ga10-ce-743
  • liferay-ga11-ce-743
  • liferay-ga12-ce-743
  • liferay-ga13-ce-743-known-issue
  • liferay-ga14-ce-743-known-issues
  • liferay-ga15-ce-743-known-issues
  • liferay-ga16-ce-743-known-issues
  • liferay-ga17-ce-743-known-issues
  • liferay-ga18-ce-743-known-issues
  • liferay-ga19-ce-743-known-issues
  • liferay-ga2-ce-741
  • liferay-ga20-ce-743-known-issues
  • liferay-ga21-ce-743-known-issues
  • liferay-ga22-ce-743-known-issues
  • liferay-ga23-ce-743-known-issues
  • liferay-ga24-ce-743-known-issues
  • liferay-ga25-ce-743-known-issues
  • liferay-ga4-ce-733
  • liferay-ga4-ce-743
  • liferay-ga5-ce-734
  • liferay-ga5-ce-743
  • liferay-ga6-ce-735
  • liferay-ga6-ce-743
  • liferay-ga7-ce-736
  • liferay-ga7-ce-743
  • liferay-ga8-ce-737
  • liferay-ga8-ce-743
  • liferay-ga9-ce-743
  • liferay-u1-dxp-7413
  • liferay-u2-dxp-7413
• 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