Re: Benchmark two separate SELECTs versus one LEFT JOIN

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Benchmark two separate SELECTs versus one LEFT JOIN
Дата
Msg-id 200501060857.56812.josh@agliodbs.com
обсуждение исходный текст
Ответ на Benchmark two separate SELECTs versus one LEFT JOIN  (Miles Keaton <mileskeaton@gmail.com>)
Список pgsql-performance
Дерево обсуждения 
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

В списке pgsql-performance по дате отправления:

Предыдущее
От: amrit@health2.moph.go.th
Дата:
Сообщение: Re: Low Performance for big hospital server ..
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Low Performance for big hospital server ..