summaryrefslogtreecommitdiffstats
path: root/README.md
diff options
context:
space:
mode:
authordanielhanrahan <daniel.hanrahan@est.tech>2023-04-13 21:01:58 +0100
committerdanielhanrahan <daniel.hanrahan@est.tech>2023-04-24 10:59:20 +0100
commit796c4dcf56a1aafc58773bedc82ddef5242a108c (patch)
treec378b9326c7f0a097a26db5fdc202353e55409e7 /README.md
parent2de9389a61f0feb37f0bcc22d6269e36dcfbd47c (diff)
Remove 32K limit from queries with collection parameters
SQL queries taking collection parameters currently create a seperate query parameter for each collection element. There is a limit of around 2^15 (32,768) query parameters. Postgres DB natively supports array types, in which the whole array is transmitted in binary as a single parameter. Changing queries to use arrays removes the 32K limit on queries. - Add support for Postgres arrays to queries - Change repository methods to use arrays, and provide overloaded versions taking collection parameters - Update tests to reflect 32K limit being lifted Issue-ID: CPS-1573 Signed-off-by: danielhanrahan <daniel.hanrahan@est.tech> Change-Id: I64f2aeaedbe54bfe12e3079cba0f2216759142c3
Diffstat (limited to 'README.md')
0 files changed, 0 insertions, 0 deletions