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.

How to solve these three steps as my hosting company told me?

Discussion in 'MySQL' started by bilal bhatti, May 23, 2016.

0
  1. #1
    There are 3 things that will resolve MySQL performance issues and they are as follows:

    1. Remove the code that generates the offending query all together.
    2. Institute proper table indexing for tables whereupon the bad queries are being executed. Proper indexing is explained in our help desk and is the most ideal solution
    for any MySQL performance issues.
    3. Rework the query that is responsible for the performance issue so that it can perform the same task without having to perform as large a query. This solution is not
    plausible in all circumstances, will require intimate knowledge of the tasks at hand to elicit a better query, and will often achieve modest gains at best. This option is
    often best implemented in addition to #2 as the combination of a better query and proper indexing will obviously yield substantial benefits.
     
    bilal bhatti, May 23, 2016 IP
  2. PoPSiCLe

    PoPSiCLe Illustrious Member

    Messages:
    4,623
    Likes Received:
    725
    Best Answers:
    152
    Trophy Points:
    470
    #2
    That is completely impossible to say, given that you give no information about what problems you're trying to solve (apart from it bring a performance issue).
     
    PoPSiCLe, May 23, 2016 IP
  3. sarahk

    sarahk iTamer Staff

    Messages:
    28,500
    Likes Received:
    4,460
    Best Answers:
    123
    Trophy Points:
    665
    #3
    Are you running scripts you've written yourself, or something you've just installed?
     
    sarahk, May 23, 2016 IP