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 <[email protected]> wrote: > 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/ >
--------------------------------------------------------------------- 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/
