One big query or a thousand small ones?

[Manixat]

Hello again freaks,

 

 

I have a dilemma here that I thought I would ask for a professional opinion.

 

 

 

$mysqli->query("SELECT * FROM `table` WHERE `id`='$id1' OR `id`='$id2' OR `id`='$id3' ... OR `id`= '$id3001' OR `id`='$id3002'");

or

$mysqli->query("SELECT * FROM `table` WHERE `id`='$id1'");
$mysqli->query("SELECT * FROM `table` WHERE `id`='$id2'");
$mysqli->query("SELECT * FROM `table` WHERE `id`='$id3'");
...
$mysqli->query("SELECT * FROM `table` WHERE `id`='$id3001'");
$mysqli->query("SELECT * FROM `table` WHERE `id`='$id3002'");

 

which is the better way to go?

[awjudd]

One big query.  It can hit the index once and do it's business.  Since you are doing ORs, you may want to consider switching it to an IN clause.

 

 

SELECT * FROM `table` WHERE `id` IN ( $id1, $id2 )

 

~awjudd

[Manixat]

One big query.  It can hit the index once and do it's business.  Since you are doing ORs, you may want to consider switching it to an IN clause.

 

 

SELECT * FROM `table` WHERE `id` IN ( $id1, $id2 )

 

~awjudd

 

Excellent, thank you for this reply!