diff options
| author |   danielhanrahan <daniel.hanrahan@est.tech> | 2023-04-13 21:01:58 +0100 |
|---|---|---|
| committer | danielhanrahan <daniel.hanrahan@est.tech> | 2023-04-24 10:59:20 +0100 |
| commit | 796c4dcf56a1aafc58773bedc82ddef5242a108c (patch) | |
| tree | c378b9326c7f0a097a26db5fdc202353e55409e7 /cps-service/src | |
| parent | 2de9389a61f0feb37f0bcc22d6269e36dcfbd47c (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 'cps-service/src')
0 files changed, 0 insertions, 0 deletions