On 17 Nov 2003 at 0:01, rockwithme77 wrote:

>When I start my application, I want to pin student lastnames with
>their IDs in the main memory -> I want to fire a set of queries, the
>resultset of which is persistent in the application level.
>
>What do I need to do to achieve this?

Issue query, fetch the result set and store it into memory. How?
Depends on your preferable language/programming skills.
I wouldn't suggest to make your data cache dynamic (automatically
refreshed). Many troubles for miserable profit.

SY, Dimitry Sibiryakov.