Toggle Categories

What is faster, JOIN or SELECT from multiple tables?

May 01, 2014

Compare speed of 2 SQL queries: SELECT fname FROM blog JOIN users USING (usersID) and SELECT fname FROM blog, users WHERE blog.usersID=users.usersID. See result below:

 
Blog table - 8,568 records
Users table - 12,215 records
Runs - 5,000
 
SELECT fname FROM blog JOIN users USING (usersID)  -  0.0051216512203217 seconds
SELECT fname FROM blog, users WHERE blog.usersID=users.usersID  - 0.005128585577011 seconds
 
The difference is about  0,000007 seconds  (7/100,000 ) and JOIN is less code to write.