Benchmark two separate SELECTs versus one LEFT JOIN

Поиск
Список
Период
Сортировка
От Miles Keaton
Тема Benchmark two separate SELECTs versus one LEFT JOIN
Дата
Msg-id 59b2d39b0501051831643e90f2@mail.gmail.com
обсуждение исходный текст
Ответы Re: Benchmark two separate SELECTs versus one LEFT JOIN
Список pgsql-performance
Has anyone seen a benchmark on the speed difference between:

SELECT * FROM item WHERE id=123;
and
SELECT * FROM vendor WHERE id=515;

versus:

SELECT * FROM item LEFT JOIN vendor ON item.vendor_id=vendor.id WHERE
item.id=123;



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.

Thanks!

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

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: Low Performance for big hospital server ..
Следующее
От: William Yu
Дата:
Сообщение: Re: Low Performance for big hospital server ..