Re: Fetching multiple rows in single round trip

Поиск
Список
Период
Сортировка
От Jon Smark
Тема Re: Fetching multiple rows in single round trip
Дата
Msg-id 1337375163.42256.YahooMailNeo@web112813.mail.gq1.yahoo.com
обсуждение исходный текст
Ответ на Re: Fetching multiple rows in single round trip  (David Johnston <polobo@yahoo.com>)
Ответы Re: Fetching multiple rows in single round trip
Список pgsql-general
Hi,

> ...WHERE wid = ANY(string_to_array(?,';'))
>
> where the ? is a parameter that you replace with a semi-colon delimited listing of widget IDs
>
> Performance depends on specifics you have not provided, especially the expected number of widgets you are going to be
filteringone. 


Thanks for the reply.  The number of widgets is variable, but should not be higher than about 20 in the worst case,
with10 being 
a more average number.  Which solution should I opt for in these circumstances?

Cheers,
Jon


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