Memory Table

[salman]

Hello
We are working on an stock market application to buy and sell stock
market shares. Clients are connected through local lan, we are easily
maintaining and updating the client database when client perform any
operarion like sell/buy shares to insert/update database table row. We
are planing to use our applicaion from dailup connection or from
internet, but we are facing a problem due to using normal database
operation like insert/delete/update, which takes lots of time on
internet while our application requiment is real time operation.

So we plan to use 'In-Memory Database Tables' or 'Memory Tables', sort
of thing in client application so that client could not change the
database entries manually and application could perform easily and
fastly.

We are supposing that client system does not have any database like sql
or oracle etc. And also we don't want to change our client application
(something will be possible). we want to create tables in client memory
so that our application read/update data from memory table (like
read/update from database table) to save time, we known that there
would be requirement of loading data in clinet memory each time the
client application start or connect with server (like - we have to do
synchronize all ServerData and MemoryData at start of application)

My question is that how can we create memory tabels like tables in
database, and easily get the data from memory table, is there any API
available to create these things, or we have to create our own API, or
any other solution for that problem.

Thanks.

Salman