Dear all, Searching in cmdb is really slow. Statistics overview takes a long time to load. These problems are probably somehow related to xml_storage which is getting quite big.
searching in cmdb really slow : SELECT DISTINCT(xml_key) FROM xml_storage http://bugs.otrs.org/show_bug.cgi?id=8432 statistics overview takes a long time to load http://bugs.otrs.org/show_bug.cgi?id=7874 This happens on two systems (which were once identical) on OTRS 3.0.11 and OTRS 3.1.5. Both use postgresql for a database backend. The queries which are running while waiting do a SELECT DISTINCT on xml_storage. I have reported two bugs but didn't receive any feedback. What's the best way to proceed to solve my problem ? Thank you very much in advance, Met vriendelijke groet, Roald Hopman Open Source Consultant Industrial TSI B.V. T: +31 30 600 50 10 www.industrial-tsi.com <http://www.industrial-tsi.com>
--------------------------------------------------------------------- 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