I have about 200000 ticket managed but smaller disk space on filesystem (note that many ticket have been deleted on the system because they were spam or viruses) I had a proble on dec 1st when the ticketcounter has been resetted to 0 I've now changed back the conter to 240000 and I'll see if it happens again. Is there a protection that avoid the system to use twice the same ticket number? Ciao AleX -----Messaggio originale----- Da: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] Per conto di Daniel Balan Inviato: giovedì 9 dicembre 2004 12.13 A: otrs@otrs.org Oggetto: [otrs] How big can OTRS be ? Hello OTRS, I have a question about how big OTRS can be. For example my OTRS has at this moment almost: 50 000 tickets and more than 150 000 articles. The articles are kept in the file system and the size exceed 20 Gb. I am using MySql on Linux (fedora core). Does any one has a similar installation? Do you have any idea how big OTRS can be? Regards, Daniel -- This message was scanned for spam and viruses by BitDefender For more information please visit http://www.bitdefender.com/ _______________________________________________ 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 oder Consulting f|r Ihr OTRS System? => http://www.otrs.de/

Outside of the physical limits of the host system (which should be easy to manage locally), the primary constraint is probably the capabilities of the backend database in use. On the latter your mileage may vary, and one should check with the authors and support team of your database of choice. However, I do think some thought should be given to an archive mechanism where closed tickets of a user defined age, and invalid customer, agent, and queue data can be stored after clean removal from the active otrs database. Not a trivial task I know, but if one has a very busy system one does not want things to get to slowed down by dead data, and as closed tickets records are retained this could become significant. On the other hand deleting records completely may loose important or useful data that may be useful to access at a later date. An archival mechanism would give the option of gracefully ageing data, and optimising performance. On Thu, 2004-12-09 at 11:13, Daniel Balan wrote:

Hello OTRS,

I have a question about how big OTRS can be. For example my OTRS has at this moment almost: 50 000 tickets and more than 150 000 articles. The articles are kept in the file system and the size exceed 20 Gb. I am using MySql on Linux (fedora core).

Does any one has a similar installation? Do you have any idea how big OTRS can be? Regards,

Daniel -- Meum est propositum In tabernum mori,

Graham Smith