The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

FabioG's avatar
FabioG
Contributor II
1 year ago

SQL Optimization

Hi all, just finished to see the "Mining for Gold: SQL Parametrization", very informative episode. At the end, Chris Loran explained how to leverage on caching system offered by "globals", to avoid ...
Data Sources
FabioG's avatar
FabioG
Contributor II
1 year ago

Hi Chris,

thanks a lot for you (very) quick answer. 

I agree with You, never put too much data in cache, it may be inefficient.

I'm doing some experiment with globals, I'm trying to understand how they works. They are somehow managed by the OS's objects lifecycle, I guess. So there's no need to keep keys alive for a bunch of time (like Redis does), and there's no need to delete single stored keys (the Clear method removes ALL the keys, a sorto of cleanup)

While I'm learning OS, I'm trying to figure out if a Cache Server like Redis would help, just an idea.

Thanks again for Your time.

Best regards

FabioG