August 15th, 2013, 05:16 PM
In my page, I have multiple queries to fetch data from same table with different scenarios. These multiple queries give me performance issues. So I am trying to cache the table and then query that with different scenarios and in this way I don't need to hit the database all the time.
But, I don't know how to cache the table and query from it.
Can anyone help?
Is there any other way to improve the performance?
August 20th, 2013, 07:03 AM
Have you found the heavy queries and optimized them by checking the execution plan, possibly rewriting them and added/changed indexes?
Originally Posted by georgenight
If you post the query, the output from EXPLAIN and the CREATE TABLE statements for the table involved we might help you to optimize it.