Re: DBModelled Storage in JAVA

JK wrote: 
Hi all,

Here goes my requirement . I hava a set of tables in Database , which
will be accessed by my application frequently . My application has to
answer a lot of queries and that too a lot faster for which the
database is not able to cope up with. So Iam in need to store all the
values in memory for faster retreival.

 Is there any specific methodology to store all the values in the table
as it is present in the database
( am i clear here) or should i remodel the data and store it using
Collection (Vector,Hashtable etcc...) objects.

Is there any tool/project available satisfying the above requirement ?
i.e storing all the table data in memory so that i can retreive them
using Java Objects.  It would be nice if its free too !!

Thanks for your help.

Regards
JK

Not sure if this is a suitable answer. You can change your database to HSQLDB. You can run your DB from memory. http://hsqldb.org/

--


Thanks in Advance...
IchBin, Pocono Lake, Pa, USA http://weconsultants.servebeer.com/JHackerAppManager
__________________________________________________________________________

'If there is one, Knowledge is the "Fountain of Youth"'
-William E. Taylor,  Regular Guy (1952-)
.