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 similar results as the index you are proposing, can you check please? Regards, mg Am 05.08.14 um 16:39 schrieb AL: > > 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 -- Martin Gruner Senior Developer R&D OTRS AG Bahnhofplatz 1a 94315 Straubing T: +49 (0)6172 681988 0 F: +49 (0)9421 56818 18 I: www.otrs.com/ Geschäftssitz: Bad Homburg, Amtsgericht: Bad Homburg, HRB 10751, USt-Nr.: DE256610065 Aufsichtsratsvorsitzender: Burchard Steinbild, Vorstand: André Mindermann (Vorsitzender), Christopher Kuhn, Sabine Riedel Neugierig auf OTRS 3.4? - Besuchen Sie uns auf der IT & Business in Stuttgart vom 08.-10. Oktober 2014! - Hier geht es zu Ihrer Messefreikarte: http://www.otrs.com/otrs-auf-der-messe-business-vom-8-10-10-2014-stuttgart/?lang=de --------------------------------------------------------------------- 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
