mysql, query performance question

[mark_me]

If one has to select about 30-100 different rows from a table based on their ids... which one is best approach: 1. select * from table where id1=3 or id1=9 or id1=200 or id1=205 ... or 2. using a loop... eg foreach(string id in ids) { stmt="select * from table where id3="+id } thankyou for guidance...

[Adam Maras]

Generally speaking, the fewest trips between the database client and the server, the better the application will perform. This is especially true for queries that return small amounts of data. For this reason, option #1 is more likely to perform better.

Adam Maras | Software Developer Microsoft Certified Professional Developer

[Mycroft Holmes]

Does MySql not have an IN operation, I hate using OR in a where clause.

Select * from Table where ID in(1,23,4,56,700)

Never underestimate the power of human stupidity RAH

[Robin_Roy]

Based on the 2 options that you gave, the first option is better.

[mark_me]

thankyou

[mark_me]

thankyou all