Hello Andre,
ah, thank you. We have a similar new index already in the database
upgrade script for OTRS 3.4, like this:
DROP INDEX dynamic_field_value_field_values ON dynamic_field_value;
CREATE INDEX dynamic_field_value_field_values ON dynamic_field_value
(object_id, field_id);
This should have
ALTER TABLE otrs.dynamic_field_value ADD INDEX speed (field_id , object_id )
should improve the performance too.
On 08/05/2014 12:39 PM, Martin Gruner wrote:
Hello André,
unfortunately this would break DynamicFields such as Multiselect which
need to store more than one row per field entry.
Hello André,
unfortunately this would break DynamicFields such as Multiselect which
need to store more than one row per field entry. Please investigate if a
regular index (rather than a unique index) would also improve the
performance.
Regards, mg
Am 04.08.14 um 19:58 schrieb AL:
> A way to impr
