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:are.hoel@telio.no] Sent: Friday, March 18, 2005 5:16 AM To: otrs@otrs.org 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/