Re: MySQL performs very very slow
If you can't post your query, maybe you can post the result of "EXPLAIN yourquery". It could help. If it results that MySQL doesn't use indexes, try using FORCE INDEX.
Can't your query be cached?
Another (very dirty) suggestion: even if your main tables need to be InnoDB, can't you create a MEMORY summary table?
Subject
Views
Written By
Posted
13278
February 15, 2005 03:39PM
4170
February 18, 2005 12:37AM
4358
February 18, 2005 03:32PM
3528
February 23, 2005 06:32PM
3552
February 23, 2005 06:42PM
3791
March 14, 2005 06:13AM
Re: MySQL performs very very slow
3619
February 18, 2005 03:17PM
3282
February 21, 2005 01:41AM
3074
February 23, 2005 05:29PM
3160
February 23, 2005 06:39PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.