beleapeplalry
New Member
Dev: i3-2100 (4core) 3.1GhzLive: E3-1220 (4core) 3.1GhzEverything else is pretty much identical - 4gb ram, 500gb sata hds (raid 1)..When running this query on Dev, the query is on the \[code\]show processlist;\[/code\] for less than 1s, Yet on Live it will process the query then move to 'copying to tmp table' and ride to 300 (time) and pretty much timeout from what I can tell.Please ask for more info and I will provide what I can find.I've pretty much come to the conclusion that the tmp table is needed when using ORDER BY.Is anyone able to see why the live server would be causing this slow down?, Ive ran these queries when both live and dev had no other queries running.Query:\[code\]SELECT pchu.project_company_has_user_id, pchu.project_company_has_user_project_id, pchu.project_company_has_user_user_id, c.company_id, c.company_hall_no, c.company_type, c.company_company_name, c.company_stand_number, c.company_locked, c.company_country, c.company_ready_for_page, c.company_image_file_1, u.user_id, u.user_username, p.project_id, p.project_name, fqha.form_question_has_answer_id, fqha.form_question_has_answer_request FROM project_company_has_user pchuLEFT JOIN company c ON pchu.project_company_has_user_company_id = c.company_id LEFT JOIN user u ON pchu.project_company_has_user_user_id = u.user_id LEFT JOIN project p ON pchu.project_company_has_user_project_id = p.project_id LEFT JOIN form_question_has_answer f ON pchu.project_company_has_user_user_id = f.form_question_has_answer_user_id AND (f.form_question_has_answer_form_id = 174) WHERE (p.project_id = 29 AND pchu.project_company_has_user_garbage_collection = 0) ORDER BY company_company_name asc LIMIT 25\[/code\]