Hi Rafael

As documented on the Service Studio help topic About Caching Contents, there's an in-memory cache per each Front-end,w chih means that if the query was first executed on HUBSERVER001, when executed with the same input paramters on front-end HUBSERVER002 it will be executed again against the database engine, and then cached on HUBSERVER002.

As you say, the cache is local, and is not shared between servers, so answering to your question, the platform will retrieve the data again from the database and cache it on HUBSERVER002.

Going a little deeper ont he cache architecture, the cache isn't just saved locally at the front-end level, but at the worker process level within IIS. This means that if you have the same application being server by multiple worker processes (alas, not recommended by OutSystems), you'll have 2 caches, and when the query first executes on one worker process, the cache will not be available on the other worker process.

With this in mind, in order to take maximum advantage of Agile Platform cache and achieve maximum performance on the applications, make sure that each application runs only on one worker process (no web garden), and if using load balancer activate the sticky session per front-end, to minimize the number of query executions within the same user session.

Cheers

Miguel Simões João