Martin, thanks!!!
How about the table type. Are you using MyIsam or InnoDB?
Thanks again,
Ronaldo
On Mon, Apr 6, 2009 at 1:23 PM, Martin Edenhofer
Hi Ronaldo,
it's not really a developer question, but anyway. ;)
My personal feedback is MySQL, because I already saw really fast installations with about 20k ticket a day. MySQL is lacking some enterprise features this makes the database really fast.
One more info, if you have so many tickets a day, you should think about to use the file system storage for attachments. So backup and restore of your database (in case of 200GB :-D ) this will be easier (about 90% of the database size are attachments of email or notes).
I also recommend you the OTRS Support addon, which shows you several system checks depending you your system (also performance tips, recommended settings, ... ). Just install it over the package manager in the admin interface from ftp.otrs.org.
Greetings to Brazil! ;)
-Martin
On Apr 6, 2009, at 17:59 , Ronaldo Richieri wrote:
Hi!
I'm in a project where we are going to install an OTRS to a huge university here in Rio de Janeiro (Brazil).
They are expecting about 5,000 tickets per day. I don't if this is a lot of information for a MySql installation, so I have this question:
Is a MySql installation a good choose for us? Or should I consider another DB for this project?
Why some people prefer to choose PostgreSQL or Oracle sometimes?
Thanks!!
Ronaldo Richieri Brazil +55 15 8818-2009 --------------------------------------------------------------------- OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
--------------------------------------------------------------------- OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/