Dynamic Call to static module

[amviz]

Problem Satement:

We have a module accessing database which is called around million times a day. This is a severe hit on the apps performance. We are thinking of an option where we could compile the called module as static and keep the call dynamic from the called module.

This way we will introduce a working storage call which will be retained until and unless the called module is loaded again.

1. Is the above possible?
2. What do we need to change in the compiler option to compile a module as static?