Miles,
> I only have a laptop here so I can't really benchmark properly.
> I'm hoping maybe someone else has, or just knows which would be faster
> under high traffic/quantity.
Well, it's really a difference between round-trip time vs. the time required
to compute the join. If your database is setup correctly, the 2nd should be
faster.
However, it should be very easy to test ....
--
Josh Berkus
Aglio Database Solutions
San Francisco