When using the translate-plugin with models where ID is an integer, the index on the model_id column is not use in MySQL versions 8.0.40 and 5.7.44.

[i3bepb]

When using the translate-plugin with models where ID is an integer, the index on the model_id column is not use in MySQL versions 8.0.40 and 5.7.44.

The current implementation with integer ID models causes inefficient index usage where only the model_type index is employed, leading to excessive row scanning. Suggested solution: modify the model_id data type and implement a compound index.

After

[daftspunk]

Yes, we identified the same issue in the core with the system_files table. As such, it no longer supports "uuids" due to the significant performance gain.

Take a look at System\Console\OctoberUtilPatches and the utilPatch2Point0 method. It has a "safe" approach to migrating away from string keys.

[daftspunk]

Related issue #756