Efficient way to query database from an array

Question

I have an array containing about 400 10-20 character, single string number items. I want to query my database from this array in the most efficient way (on server load and load time) possible. Here is what I have currently but it takes about 4-6 seconds to load the page.

foreach(unserialize(mysqli_fetch_array(mysqli_query($database, "SELECT `array` FROM `users` WHERE `id` ='00000001'"))[0]) as $value) {
    $friend_id = mysqli_fetch_array(mysqli_query($database, "SELECT `id` FROM `users` WHERE `id` ='".$value."'"))[0];
    if(!empty($friend_id)){
        echo mysqli_fetch_array(mysqli_query($database, "SELECT 'username' FROM `users` WHERE `id` ='".$value."'"))[0] . "<br />";
    }
}

No, you shouldn't. It creates problems like the one you're having, and it makes your database PHP-dependent. — ironcito, Commented Aug 10, 2013 at 1:51

SteAp · Accepted Answer · 2013-08-10 01:31:13Z

0

Look out for JOINs in SQL, e.g. at this page.

answered Aug 10, 2013 at 1:31

SteAp

12k12 gold badges56 silver badges95 bronze badges

Add a comment |

Collectives™ on Stack Overflow

Efficient way to query database from an array

1 Answer 1

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related