Thread: Caching table

    #1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2013
    Posts
    1
    Rep Power
    0

    Caching table


    Hi,

    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?
  2. #2
  3. No Profile Picture
    Problem Solver
    Devshed Specialist (4000 - 4499 posts)

    Join Date
    Jan 2001
    Location
    Stockholm, Sweden
    Posts
    4,495
    Rep Power
    534
    Originally Posted by georgenight
    Is there any other way to improve the performance?
    Have you found the heavy queries and optimized them by checking the execution plan, possibly rewriting them and added/changed indexes?

    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.
    /Stefan

IMN logo majestic logo threadwatch logo seochat tools logo