Hi @Sumesh Sukumaran,
Yiu can potentially store millions of user entries in OPA, it depends on how many attributes you have per one. If you're talking just unique ids in a hash map it will likely work.
I'm not sure what you mean by a centralized OPA cache. The cache in OPA is its own memory.
You can have OPAL fetch data from wherever you want into OPA. Including from a centralized source of course.
You can also use http.send in your rego policies, but in general I wouldn't recommend it, as it has great potential of hurting system stability and performance.