Hello! I've seen an option to use a different database for searches in the config files, but I don't remember which one is it right now. Using one would make sure that those long searches won't affect the rest of your OTRS, but I don't know how both databases are kept in sync. Read the doc's, maybe there's explained with more detail. Regards, On 18 Mar 2005 at 7:30, Jack Doyle wrote:
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/ _______________________________________________ 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/
--- Victor R. Rodriguez Departamento de Sistemas Valoraciones del Mediterraneo, S.A. ---