You might want to check out this bug regarding using ArticleStorageSwitch.pl on very large databases: http://bugs.otrs.org/show_bug.cgi?id=4115
Regards, -- Michiel Beijen Software Consultant +31 6 - 457 42 418 Bee Free IT + http://beefreeit.nl On Fri, Aug 14, 2009 at 12:27, Lars Monsees <l.mons...@atlantismedia.de>wrote: > > - do you know another tool to optimise the database ? > > you could use the mysql command line client to connect to the DB and > execute the following: > OPTIMIZE TABLE otrs.article_attachment, otrs.article_plain; > > > - how can execute the process in steps ? the first time the process > doesn't finish correct. > > I was just guessing that you perhaps could start the script a second time > and it would continue with the missing stuff. As my database was updated > with the first run, this wasn´t necessary for me and so I don´t know if it > possible at all =) > > --------------------------------------------------------------------- > 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 > > NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! > http://www.otrs.com/en/support/enterprise-subscription/ >
--------------------------------------------------------------------- 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/