1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

caching table

Discussion in 'MySQL' started by georgenightjr, Aug 15, 2013.

  1. #1
    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?
     
    georgenightjr, Aug 15, 2013 IP
  2. sarahk

    sarahk iTamer Staff

    Messages:
    28,494
    Likes Received:
    4,457
    Best Answers:
    123
    Trophy Points:
    665
    #2
    "hitting the database" shouldn't be a problem - I'd look at how well your queries are written, how much data you are pulling back and how well indexed it is before I looked at the caching you describe.
     
    sarahk, Aug 16, 2013 IP