21979 - On Test, The EFT linkage Modal Take a long time to load

bcgov / sbc-pay

ServiceBC common payment services for one-time and long-enagement partners

Apache License 2.0

8 stars 39 forks source link

21979 - On Test, The EFT linkage Modal Take a long time to load #1647

Closed seeker25 closed 3 months ago

seeker25 commented 3 months ago

Issue #: https://github.com/bcgov/entity/issues/21979

Description of changes: Move multiple outer joins to a subquery join, also change some of the outer joins into inner joins

By submitting this pull request, I confirm that you can use, modify, copy, and redistribute this contribution, under the terms of the sbc-pay license (Apache 2.0).

seeker25 commented 3 months ago

Closed and reopened because I wasn't sure if this code works on a search basis, but it still took 8s to look up a single account id