MySQL query optimization help

Discussion in 'MySQL' started by DanielHB, Mar 29, 2009.

0
  1. #1
    I have the following two queries which really do need optimizing although not being a mysql expert I am unsure how to do it myself. Can anyone help?


     
    DanielHB, Mar 29, 2009 IP
  2. wwwbryan

    wwwbryan Well-Known Member

    Messages:
    181
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    103
    #2
    What do you mean optimization? I think that is as optimized as your going to get it.

    The query itself can't be optimized, but I think you confused that with the tables in the database.
     
    wwwbryan, Mar 29, 2009 IP
  3. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #3
    Nothing you can really do for the actual queries.

    Make sure you have a unique index on: sites.username, and possibly one on stats.unq_pv_overall.

    Is there a specific problem you're experiencing?
     
    jestep, Mar 30, 2009 IP