Hi Dan,
Thanks for reaching out! It is exciting to hear about your efforts at OVO in the Green Cloud space! Currently, our efforts to build around scalability and combat the memory issues for NodeJS revolve around the implementation of MongoDB. We are close to issuing a CCF release that will provide full integration for MongoDB, which will enable you to gather data in chunks by paginating the API request. This feature will not improve the length of time it takes to query AWS, which is why we suggest seeding your cache file (MongoDB) one day at a time for large amounts of data. The implementation of MongoDB should also improve seeding the cache process.
Regarding our UI, it is not currently built to scale with large amounts of data. For this reason at this time, we would suggest only using the UI dashboards to analyze smaller data time frames, or potentially using a separate tool like Data Studio to consume the CCF data and handle larger data sizes.
We would love to learn more about your goals and commitments at OVO and would be very interested to connect if you would like to hop on a call and discuss in more detail!
Thanks,
CCF Team