[Catalyst] Speed up Cat

[Will Smith]

Hi,
    I have a Cat app launched and running. Everything is fine until lately, it becomes very slow in responding to queries. Sometimes takes minutes. I have the latest verison of Cat, running on Linux, Apache 2. According to the docs, apache is pretty fast, so I wonder if there is anyway to speed up the queries. I have the tables indexed. The queries search through about 5 to 10 tables of more than 10 thousand records each. And the tables are growing everyday.
    Thank you
 
       
---------------------------------
Pinpoint customers who are looking for what you sell. 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/catalyst/attachments/20070831/d54b8a1b/attachment.htm