Details
-
Improvement
-
Resolution: Fixed
-
Medium
-
4.7.0, 5.0
-
None
Description
using the fetch operator with parameter hash( 'remote_id', $some_param ) will cause very slow queries on a large system, can be 10s or more for a single query if there are 1M+ objects in the db.
creating an index on ezcontentobject_tree.remote_id stops the problem, allows the db usage to go up from overloaded to running cool once more.