[Versions] Optimize database indices for better maintenance performance and disk management

[ncordonnier-datasolution]

Hello,

On one of our Pimcore 11.x instance, we have experimented

• disk space issue
• and bad maintenance performance
  due to too many versions.

After investigation, we discovered this fix [Versions] Optimize database indices for better maintenance performance #18429 .
This fix has been merge into Pimcore 12 and was planned for Pimcore 11.5.5.

Finally Pimcore 11.5.5 does not include this fix.

Is it because it is considered as an improvement and not as a fix?
Is it planned to get it a next Pimcore 11 tags?

Thank you :)

Nicolas from DATASOLUTION

[herbertroth]

@ncordonnier-datasolution This change was an improvement, not a bug fix, which is why it was not included in the 11.5.5 bugfix release. Bugfix releases only contain fixes for issues classified as bugs; improvements and enhancements are not backported into older minor versions.

[ncordonnier-datasolution]

Hello @herbertroth .
Ok, I understand why now.
Thank you for your prompt reply.
Best regards.

Thank you for your prompt reply.

[dpfaffenbauer]

@ncordonnier-datasolution to be fair, just add that index to your versions table, pimcore doesn't use ORM for these tables and nothing will change it back

[ncordonnier-datasolution]

Hello @dpfaffenbauer ,
Yes, that's exactly what we will do.
Thanks.