I am creating a custom foundset in an attempt to locally store configuration settings. I would like to hit the database only once to gather the data and then search it locally. But, I am noticing in the performance logs and trace that when a find() is performed on this custom foundset, it “seems” to be going back to the server everytime or at least it is being logged server side. So my question is, is the sv_inmem database and temp tables stored client side or are they in fact stored back on the server?
Here is the code I am using:
var _defConfigDS = databaseManager.createDataSourceByQuery("sw_defconfigs",globals.adminServer,_query,_args,-1);
globals.sw_defConfigFS = databaseManager.getFoundSet(_defConfigDS);