On 10/19/07, prakash reddy <[EMAIL PROTECTED]> wrote: > SO for us we cannot query this table because of Performance issues. > so what we did is, we have a Plugin where we have written a code which > makes a copy of every event that goes to Core table and puts in another > table. and we are querying this table. > Now we want to cache everything so that we get better performance of this > data. > > Now we have to Cache this data and we are not supposed to query the > database so
This may not be feasible if you are locked into using Oracle (but see below), but there is a DBMS caled TimesTen that already does what you are trying to do -- it's an in-memory database designed for telecommunication servers (it's now owned by Oracle, in fact). http://www.oracle.com/database/timesten.html AFAIK, it has a native C interface, as well as ODBC and JDBC, and also provides replication schemas. And this also may be of interest to you: http://www.oracle.com/database/timesten-cache-connect.html -- Brett ------------------------------------------------------------ "In the rhythm of music a secret is hidden; If I were to divulge it, it would overturn the world." -- Jelaleddin Rumi
