Re: [otrs] How to reset Ticket counters

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: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] 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 wrote:

 Ravi Shankar

----- Forwarded Message ---- From: Oliver Methfessel [MC] To: otrs@otrs.org 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