I don't think you'll experience much of a difference. The main reason we changed was because of locking issues. The problem with MyISAM is that it has locking only on tables, not rows.
On smaller databases MyISAM will actually be faster. Vennlig Hilsen / Best regards Are Hoel -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jack Doyle Sent: 18. mars 2005 13:31 To: User questions and discussions about OTRS. Subject: RE: [otrs] Default search settings good question. I'll also be interested in that answer. By the way, are there any advantages to using the InnoDB tables with a smaller database? ----- Jack Doyle, Network+ Systems Operations Specialist Lewis-Gale Clinic Information Systems -----Original Message----- From: Are Hoel [mailto:[EMAIL PROTECTED] Sent: Friday, March 18, 2005 5:16 AM To: [email protected] Subject: [otrs] Default search settings Hi We have reached a large amount of tickets and articles in our system. This makes free text searches slow and demanding. Our first step to limit the problem was to change all tables from MyISAM to InnoDB. This removes the locking issue presented by 30 second long searches. Now we want to make searching for tickets an easier job on the system. We are looking into different methods to do this and have come to the conclusion that limiting the timeframe for searches must be the way to go. The big issue here is setting a limit of e.g. 2 months as a "default" for all searches. It should be as simple as setting the default form values. Is there a way to do this? Best regards Are Hoel _______________________________________________ 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/ _______________________________________________ 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/ _______________________________________________ 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/
