Hi:

A friend of mine and I are working on a map image generator in PHP. For each street-change point we have a MySQL entry. When calling out the coordinates based on street ID constraints, we can either do a query for each street:

Code:
SELECT * FROM street_coords WHERE street_id=ID;
or one big query for all the ID's required:

Code:
SELECT * FROM street_coords WHERE street_id=ID1 OR street_id=ID2 OR street_id=ID3 ... ;
Which method is better, performance-wise? Obviously, we are working with large amounts of data (thus calling large amounts of small queries or a huge single query).

Thanks a bunch.

Mikhail