Which query would be faster

[Bob Van Der Ploeg]

Which would be faster a single

select * from table where part in (A12345,1FB2356,346C79,349872)

or multiple

select * from table where part="A12345"
select * from table where part="1FB2356"
select * from table where part="346C79"
select * from table where part="349872"
Table has 450,000 rows
+-------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+-------+
| part | char(10) | YES | MUL | NULL | |
| descr | char(9) | YES | | NULL | |
| list | decimal(7,2) | YES | | NULL | |
| trade | decimal(7,2) | YES | | NULL | |
| cost | decimal(7,2) | YES | | NULL | |
+-------+--------------+------+-----+---------+-------+

[Christoph Schmitz]

I would have guessed on the first one.
My expericence say that one query is faster than many. *

* depends on the querystructure.

Christoph Schmitz
"Bob Van Der Ploeg" <bo*@vdpcorp.com> wrote in message news:<es********************@twister.tampabay.rr.c om>...

Which would be faster a single

select * from table where part in (A12345,1FB2356,346C79,349872)

or multiple

select * from table where part="A12345"
select * from table where part="1FB2356"
select * from table where part="346C79"
select * from table where part="349872"
Table has 450,000 rows
+-------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+-------+
| part | char(10) | YES | MUL | NULL | |
| descr | char(9) | YES | | NULL | |
| list | decimal(7,2) | YES | | NULL | |
| trade | decimal(7,2) | YES | | NULL | |
| cost | decimal(7,2) | YES | | NULL | |
+-------+--------------+------+-----+---------+-------+

[Christoph Schmitz]

I would have guessed on the first one.
My expericence say that one query is faster than many. *

* depends on the querystructure.

Christoph Schmitz
"Bob Van Der Ploeg" <bo*@vdpcorp.com> wrote in message news:<es********************@twister.tampabay.rr.c om>...

Which would be faster a single

select * from table where part in (A12345,1FB2356,346C79,349872)

or multiple

select * from table where part="A12345"
select * from table where part="1FB2356"
select * from table where part="346C79"
select * from table where part="349872"
Table has 450,000 rows
+-------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+-------+
| part | char(10) | YES | MUL | NULL | |
| descr | char(9) | YES | | NULL | |
| list | decimal(7,2) | YES | | NULL | |
| trade | decimal(7,2) | YES | | NULL | |
| cost | decimal(7,2) | YES | | NULL | |
+-------+--------------+------+-----+---------+-------+