How to JOIN Tables with MySQL

In this article, I will talk about the speed of the JOIN table in various forms of MySQL, which will be useful. In choosing the right command style in order to get the fastest results

The test is nothing much. I tested the functionality on phpMyAdmin and then saw the results of the query speed from phpMyAdmin. If applied to other tests, try it.

Testing, I chose the test command in the JOIN group to select all the data to be displayed. It is a query that gives the same result in 3 types without sorting.

SELECT I.*,T.*
FROM eduparty_index AS I INNER JOIN eduparty_template AS T
ORDER BY I.username

3,060 total, keywords lasted 0.1406 seconds

SELECT I.*,T.*
FROM eduparty_index AS I CROSS JOIN eduparty_template AS T
ORDER BY I.username

3,060 total, keywords lasted 0.1145 seconds

SELECT I.*,T.*
FROM eduparty_index AS I,eduparty_template AS T
ORDER BY I.username

3,060 total, keywords lasted 0.1043 seconds

The total time obtained is the average time for each order, 10 times, all with the same result. Try to choose And don't miss the small significance of these matters Which will have more effects If your system is getting bigger.