Implement a caching system

[jschaeff]

In order to avoid query flooding and provide fastest replies, implement the caching of the request.

See https://docs.python.org/3/library/functools.html and https://realpython.com/lru-cache-python/

[vpet98]

I found a way to use the cache decorators like this:

@view_config(route_name='dataselectrestricted', openapi=True)
def restricted(request):
    return to_call(request)

@lru_cache
def to_call(request):
    # real /restricted method code here

But I am not sure if this benefits our service in any way. After testing it, I don't see it being faster. I believe that cache would be helpful, for example, in case a function is called with the same parameters over and over again, probably by another function or itself.

[jschaeff]

Thank you for exploring this. I think we can put this in ultra low priority.