make some adjustments to the Agent API

## Source

https://github.com/ArctosDB/dev/issues/384

## Summary

There are some bottlenecks in the agent api, following the recipe used by the catalog api might provide significantly better performance for certain queries.

Investigate.
