Timeline for JOIN in 4 tables gets phpmyadmin unresponsive
Current License: CC BY-SA 4.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 21, 2019 at 12:22 | comment | added | leeand00 | Another thing you can do it create a filter on date range so that it only pulls that date range; that will also limit the number of records returned. | |
| May 21, 2019 at 12:17 | comment | added | leeand00 | Right; take a key from another “Rick James” and “break it down” into ‘VIEW’s or temporary tables. | |
| May 21, 2019 at 12:05 | vote | accept | gallo2000sv | ||
| May 21, 2019 at 12:05 | comment | added | gallo2000sv |
Even though I suspected the parentheses and inner doesn't affect the query as @Rick James said. It seems to be working with the LIMIT clause. I think it's a hardware problem trying to use too much RAM to retrieve so many rows. SOLUTION: I will try to split the the JOINS and will use a temporary table to improve the performance and reduce the processing time. Thanks a lot for the insights :)
|
|
| May 21, 2019 at 5:00 | comment | added | Rick James |
Adding a LIMIT 10 may not help -- if it is spending lots of time before getting to the LIMIT.
|
|
| May 21, 2019 at 4:59 | comment | added | Rick James |
In MySQL, INNER JOIN is identical to JOIN. And I doubt if the parentheses make any difference in this case.
|
|
| May 21, 2019 at 0:44 | comment | added | leeand00 |
You should probably change your fields to a count(*) so you can see how many records would be returned. The query is likely timing out before it returns. I didn't actually test it out, I took your code and made a guess based on the ERD you uploaded.
|
|
| May 21, 2019 at 0:42 | comment | added | leeand00 |
@gallo2000sv The () group together an inner join statement so that it's like one table, or one query, or one view.
|
|
| May 21, 2019 at 0:37 | comment | added | leeand00 |
@gallo2000sv Try splitting the joins into VIEWs or add a LIMIT clause for the first 10 results, just to see if it works at all.
|
|
| May 20, 2019 at 23:37 | comment | added | gallo2000sv |
Thanks a lot. But still no result from the query it becomes unresponsive after several minutes. I could use INNER JOIN, no problem on that. Does the ( ) change something specific, or did you make any other change that i'm missing since the query looks pretty much the same...
|
|
| May 20, 2019 at 22:55 | history | answered | leeand00 | CC BY-SA 4.0 |