|
First you should start optimizing your database keys with indexes. Then optize your database server config. For certain heavy queries you can create different tables or use some kind of caching. Memory tables in mysql can also be used as aome sort of caching.
|