Re: Fetching multiple rows in single round trip

On May 18, 2012, at 17:06, Jon Smark <jon(dot)smark(at)yahoo(dot)com> wrote:

> 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 filtering one.
>
>
> Thanks for the reply. The number of widgets is variable, but should not be higher than about 20 in the worst case, with 10 being
> a more average number. Which solution should I opt for in these circumstances?
>
> Cheers,
> Jon
>

You should just try both and see which one performs better in your specific case. I do not know generally which one is best in theory.

David J.