
18 Mar
2005
18 Mar
'05
10:16 a.m.
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