Hi Dimitry,

I do not want to store it in my applications memory, but the main
memory of the server where the database is installed.

Will the DBMS support such functionality?

Regards,
sguha.

--- In firebird-support@yahoogroups.com, "Dimitry Sibiryakov"
<SD@t...> wrote:

> 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.