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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend