1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

{JOB] Need A MySQL Wizard to help with a query performance issue

Discussion in 'Hire a Freelancer' started by The Doctor, Jun 11, 2012.

  1. The Doctor

    The Doctor Jr. VIP Jr. VIP

    Joined:
    Dec 18, 2010
    Messages:
    612
    Likes Received:
    188
    Occupation:
    Computer Scientist, Engineer, Programmer.
    Location:
    ☆☆☆☆☆☆
    Do you know MySQL like the back of your hand? Joins? Composite indexes? Things like this? If so then I need your help. I have a complicated join query that's taking over 12 minutes to return over 6 million rows of data. As table b grows I fear this time will increase. If you can cut the query time down for me significantly I'll paypal you. Price is negotiable.
     
  2. azizsalim

    azizsalim BANNED BANNED

    Joined:
    Nov 12, 2011
    Messages:
    215
    Likes Received:
    17
    Check your PM.
     
  3. cyklotrial

    cyklotrial Regular Member

    Joined:
    Oct 13, 2008
    Messages:
    248
    Likes Received:
    82
    Location:
    Wonderland
    Hello FuManChu!

    Can you please send me this query, table/tables structure, avg amount of data that you have in each table that have to be used in query and of course what data you want to get from DB using your query.
    I Can't promise that i'll be able to help you but i can try.