Currently we have over 189 000 in our OTRS system with MySQL and it is little slow, but we are planning to switch to InnoDB engine soon.
Best, G. 2011/5/13 Lars Jørgensen <[email protected]>: > Hi Muhammad, > > That really depends on your hardware. OTRS scales pretty well and a system > with 80.000+ tickets is no problem. P > > There are a few tweaks available to gain performance on installations with a > lot of tickets. New to version 3 is archiving that can move old tickets out > of the main scope of the application, thus speeding up reports and searches. > > Fulltext search can take a hit with many tickets, in that case it is > recommended to switch SysConfig -> Core::FulltextSearch -> > Ticket::SearchIndexModule to "StaticDB". This creates an extra table for > searching. If you have the available disk space, you can enable StaticDB > right away. Remember to run bin/otrs.RebuildFulltextIndex.pl after switching. > > > Lars > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of > Muhammad El-Sergani > Sent: Tuesday, May 10, 2011 10:20 AM > To: User questions and discussions about OTRS. > Subject: Re: [otrs] How to reset Ticket counters > > Thanks Ravi and all, for the input. > > Any idea about when the system performance might get affected? Like > after how many tickets, or emails? > > It's a CentOS + MySQL @ OTRS 3.0.7 > > On Tuesday, May 10, 2011, ravi shanker <[email protected]> wrote: >> >> Ravi Shankar >> >> >> ----- Forwarded Message ---- >> From: Oliver Methfessel [MC] <[email protected]> >> To: [email protected] >> Sent: Mon, 25 April, 2011 8:06:14 PM >> Subject: Re: [otrs] How to reset Ticket >> counters >> >> Hi Muhammaad, >> >> Am 25.04.2011 16:29, schrieb Muhammad El-Sergani: >>> Well, being new in general to trouble ticketing systems, this might >>> sound a little bit silly. >>> >>> What I'm concerned about, is the ticket length. It is already long >>> enough, with the date and the system ID. But if I set the minimum >>> length to 2 or 3, then reset the counter every month, that would look >>> as I would be maintaining the length. >>> >>> I didn't know that stats check the counter?! >>> >> The TicketID ist the Number on which a ticketing system knows the case >> to whom the email belongs. You're right, that the default ticketformat >> is too long, have a look in the sysconfig in Core::Ticket and set >> Ticket::NumberGenerator to some other value than DateChecksum (ex. >> AutoIncrement). >> >> It isn't a good idea to reset the counter for this reason, you'll get >> many problems with >> this. >> >> Greetings >> >> Oliver >> >> -- >> Mit freundlichen Grüßen >> >> Oliver Methfessel >> >> >> Methfessel Computers >> Hauptsitz: Zieglerstr. 25a, 65191 Wiesbaden >> Kundenbüro: Kloppenheimer Weg 11, 65191 Wiesbaden >> Geschäftsführender Inhaber: Oliver Methfessel >> http://www.methfessel-computers.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 >> >> >> >> > > -- > > Thanks and Best Regards, > Muhammad El-Sergani. > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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
