Timeline for Speed up MySQL query with IN clause
Current License: CC BY-SA 3.0
16 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 24, 2014 at 20:50 | history | edited | 200_success | CC BY-SA 3.0 |
reformatted EXPLAIN output
|
| Mar 24, 2014 at 11:12 | answer | added | Leopoldo Salvo | timeline score: 3 | |
| Feb 19, 2014 at 16:13 | answer | added | rolfl | timeline score: 6 | |
| Nov 29, 2013 at 2:58 | comment | added | Malachi |
how do you know that it isn't this statement AND( bi.syouhin_sys_code LIKE '%%' OR dwh_syo.name LIKE '%%' )
|
|
| Nov 29, 2013 at 2:57 | history | edited | Malachi | CC BY-SA 3.0 |
added 1068 characters in body
|
| Nov 25, 2013 at 18:17 | history | edited | Malachi | CC BY-SA 3.0 |
this isn't the output of the query, it is result of EXPLAIN function
|
| Nov 25, 2013 at 18:07 | history | edited | Jamal | CC BY-SA 3.0 |
deleted 14 characters in body; edited title
|
| Nov 25, 2013 at 16:35 | history | edited | Malachi | CC BY-SA 3.0 |
deleted 2901 characters in body; edited tags
|
| Jun 7, 2013 at 8:17 | comment | added | Kickstart | Difficult to comment without knowing the table layouts, as I can't really see what the indexes are that it has chosen to use. However with close to 500 items in the IN clause it might well be better to instead put those items into a temp table and then join that temp table against bi_bunrui_syouhin_shop_day_jyutyuu . | |
| Jun 5, 2013 at 1:55 | comment | added | user25815 | @l0b0 I added more information | |
| Jun 5, 2013 at 1:53 | history | edited | user25815 | CC BY-SA 3.0 |
added 600 characters in body
|
| Jun 4, 2013 at 13:53 | review | Close votes | |||
| Jun 4, 2013 at 18:39 | |||||
| Jun 4, 2013 at 13:36 | comment | added | l0b0 |
Welcome to Code Review. This is a very specific question with little information about your own research into the problem, and as such is likely to be closed. Could you please add more information, for example the actual EXPLAIN output, the alternatives you've tried, and their timings?
|
|
| Jun 4, 2013 at 10:16 | review | First posts | |||
| Jun 4, 2013 at 12:49 | |||||
| Jun 4, 2013 at 10:07 | history | edited | user25815 | CC BY-SA 3.0 |
added 2991 characters in body
|
| Jun 4, 2013 at 9:55 | history | asked | user25815 | CC BY-SA 3.0 |