External Database Query - Initial Performance

In Decisions, the Agent is typically used when the external client server Decisions needs to communicate with is sitting behind a firewall. For this use case, the Agent application is installed on the client server and helps creates a secure window for Decisions to make the connections/integrations. For more, see https://documentation.decisions.com/category/administration-settings-and-advanced/agents/

Does your query return data? If the data doesnt need to be real time, caching the result of the query would help performance.

Thanks.