Fixed Registry API performance issues related to host connection pool & blocking DB IO

[t83714]

What this PR does

Fixes:

• 3463

Checklist

• [x] There are unit tests to verify my changes are correct
• [x] I've updated CHANGES.md with what I changed.

[t83714]

tested in dev clusetr