hi all i have loads of e-mails in my system and my system has become really slow. i am running OTRS on windows server 2003. i would like to know how i can clear the database by deleting all the closed tickets. i want to know if this will help increase the system speed? thank you _________________________________________________________________ "Post ads for free - to sell, rent or even buy.www.yello.in" http://ss1.richmedia.in/recurl.asp?pid=186
pri pri wrote:
hi all
i have loads of e-mails in my system and my system has become really slow. i am running OTRS on windows server 2003. i would like to know how i can clear the database by deleting all the closed tickets. i want to know if this will help increase the system speed?
thank you
What else have you got running on the Windows Server? Ideally OTRS should be on it's own server and for performance I would personally advocate a linux/unix installation rather than Windows (IMHO Apache/Perl etc. designed for Unix, afterthought to port it to Windows). Steve
Hi, You can use a Generic Agent and select Delete Ticket = Yes at the bottom of your Generic Agent task to delete old tickets from your OTRS. I don't really know if it will improve a lot your general OTRS speed, it depends mainly on how SQL statements are builds in source code ... I advise you to make a global mysqldump if you use MySQL before playing with Generic Agent and deleting tickets, then delete and test. If you see there is no real effect, you can go back with your mysql dump and input back it on your OTRS installation. You have in Documentation some tips to improve a bit OTRS speed : http://doc.otrs.org/2.2/en/html/c2449.html . Personnaly I'm skeptic about talking of "speed" under OTRS, this discussion is always coming back :o) I have always think this software is a good one for all features it offers but it is also *too* slow for my opinion, there is probably a lot of things to improve for speed in the way it's coded I think. DB backend were never the problem in all my cases and always though that Perl is the culpit. PHP/MySQL seems to me solutions easily faster than Perl one for Web applications... Best regards, Laurent Minost Le vendredi 31 août 2007 à 16:57 +0530, pri pri a écrit :
hi all
i have loads of e-mails in my system and my system has become really slow. i am running OTRS on windows server 2003. i would like to know how i can clear the database by deleting all the closed tickets. i want to know if this will help increase the system speed?
thank you
_________________________________________________________________ "Post ads for free - to sell, rent or even buy.www.yello.in" http://ss1.richmedia.in/recurl.asp?pid=186
_______________________________________________ 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 Support or consulting for your OTRS system? => http://www.otrs.com/
Laurent Minost wrote:
DB backend were never the problem in all my cases and always though that Perl is the culpit. PHP/MySQL seems to me solutions easily faster than Perl one for Web applications...
I really doubt that the language is the problem. Perl is a very mature and fast language (especially for text processing). It's possible to write slow code in any language. Someone on this list recently noticed that OTRS uses pass by value rather than pass by reference. This involves copying a lot of memory around and is slower in any language. I haven't checked whether it is true, but if it is then I guess a lot of performance could be gained from changing that for instance. I doubt a complete rewrite in PHP is going to be the answer. Nils Breunese.
Hi Nils, It would be too much work to rewrite it to PHP. But that's only an observation from myself, all tests I did to see where was the problem of this regular slow impression in OTRS leads me to the code, after eliminating Web Server performance/tuning, DB backend ... OK Perl itself (as a language) is not the culpit but maybe the way it is coded here can be improved ? Or maybe is it mod_perl ? I tried a few weeks ago to rewrite some simple parts of the code (the overview listing of CustomerUsers trough Admin Panel (AdminCustomerUser.pm)) in PHP and with the same server/db backend, i was having some response time far better (almost 2x faster) ... OK, I didn't re-coded all parts of OTRS internal systems functions but only a little part of the code and it shows me that there is some things to improve about performance ... I don't know enough Perl to discuss about pass by reference / pass by value but it can be a good thing on which it may be needed to take some time :) BR, Laurent Minost Le vendredi 31 août 2007 à 14:31 +0200, Nils Breunese (Lemonbit) a écrit :
Laurent Minost wrote:
DB backend were never the problem in all my cases and always though that Perl is the culpit. PHP/MySQL seems to me solutions easily faster than Perl one for Web applications...
I really doubt that the language is the problem. Perl is a very mature and fast language (especially for text processing). It's possible to write slow code in any language. Someone on this list recently noticed that OTRS uses pass by value rather than pass by reference. This involves copying a lot of memory around and is slower in any language. I haven't checked whether it is true, but if it is then I guess a lot of performance could be gained from changing that for instance. I doubt a complete rewrite in PHP is going to be the answer.
Nils Breunese. _______________________________________________ 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 Support or consulting for your OTRS system? => http://www.otrs.com/
Laurent Minost wrote:
OK Perl itself (as a language) is not the culpit but maybe the way it is coded here can be improved ? Or maybe is it mod_perl ?
mod_perl in itself is not slow and certainly faster than running OTRS as CGI.
I tried a few weeks ago to rewrite some simple parts of the code (the overview listing of CustomerUsers trough Admin Panel (AdminCustomerUser.pm)) in PHP and with the same server/db backend, i was having some response time far better (almost 2x faster) ... OK, I didn't re-coded all parts of OTRS internal systems functions but only a little part of the code and it shows me that there is some things to improve about performance ...
That could very well be the case. I have never taken a serious look at the OTRS code.
I don't know enough Perl to discuss about pass by reference / pass by value but it can be a good thing on which it may be needed to take some time :)
Pass by reference and pass by value are not specific to Perl, but two programming concepts that can be found in many programming languages (for instance PHP :o)). Nils Breunese.
participants (4)
-
Laurent Minost -
Nils Breunese (Lemonbit) -
pri pri -
Steven Carr