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.monsees@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/