Search Postgresql Archives

Re: Fetching multiple rows in single round trip

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux