What's better solution: mysql fetch array than object or mysql join

Question

I've work with many records and I don't know what is better solution (I mean the fastest):

    $result = mysql_query("SELECT `user_id` FROM `table_1` WHERE `user_id` = '$id'");
    while($row = mysql_fetch_array($result)) {
            $var = mysql_fetch_object(mysql_query("SELECT `row` FROM `table_2` WHERE `id` = '{$row['user_id']}'"));
            echo $var->row;
    }

or

    $result = mysql_query("SELECT t1.`user_id`, t2.`row` FROM `table_1` t1 INNER JOIN `table_2` t2 ON (t2.`id` = t1.`user_id`)");
    while($row = mysql_fetch_array($result)) {
           echo $row['row']; 
    }

Thank you for your advices! :)

Possible duplicate of mysql_fetch_array, mysql_fetch_assoc, mysql_fetch_object — Luis Teijon
– Luis Teijon, Commented Oct 24, 2015 at 17:10

MansoorShiraz · Accepted Answer · 2015-10-24 17:12:03Z

1

Whatever is handled at the database is generally faster than whatever is handled at the scripting side. So i would recommend that always go with the joins. your second part of code where you have used the SQL JOIN is better.

e.g. you can easily see that in the first code there is one extra call being made to the database which is not the case in the second code. So for every entry that is fetched in the first loop you will have to again look into the database. e.g. your first loop returns 100 records then in the second loop it will look in the database again for 100 times. so it makes it slow.

answered Oct 24, 2015 at 17:12

MansoorShiraz

1182 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

What's better solution: mysql fetch array than object or mysql join

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related