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. 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 improve the performance of OTRS:
"ALTER TABLE `otrs`.`dynamic_field_value` ADD UNIQUE `field_id` (
`field_id` , `object_id` )"
Regards,
Andre Luerssen
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs