sainandoor wrote:
> I have three tables that I am joining in order to
> get the query results I want. Each table has
> roughly 50,000 records. When I first ran the query
> I got the result in 5 sec (I have the appropriate
> indexes in place). I inserted about 100 records
> in each table the same query takes more than 1
> minute to run. I made no other change to the
> databases. Any ideas on how to get the performance
> I initially had? Is there any memory management I
> can do to restore performance. Any help is greatly
> appreciated.
Please run
http://dev.mysql.com/doc/mysql/en/optimize-table.html and get back to the forum with:
a.) the query
b.) the EXPLAIN output
Ulf