Yes . you all are True from the Database perspective.
But my requirement is necessary.
I work for convergys and we have a Well built product Infinys.
Infinys is a telecom Billing product.
We have a table in Infinys and it is COSTEDEVENT
This table is the Core table of our product. This table holds the details of
each and every event ( telephone Call details / SMS / MMS / GPRS etc ) that
were generated in the Network. so the minimum number of records in this table
are ( 5 million ) and this is a Minimum Figure
Some of our clients maintain more than 15 Million records in this table.
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 is a requirement from our perspective.
I need some help in this.
Any suggestions are welcome !
Thanks.
Cheers
Krishna kanth.
Nico Heinze <[EMAIL PROTECTED]> wrote:
--- In [email protected], prakash reddy <[EMAIL PROTECTED]>
wrote:
>
> Hi All !
>
> Now i have a special requirement which is caching the
> data of a table. This has to be developed in C++ or
> Pro * C++ and i am planning to do in C++ using OCCI or
> Pro *C
>
> Even i am not pretty clear with the idea of how to do
> it but this is the requirement that i need to achieve.
<snip>
WHY??? Databases do the caching very well on their own, so why are you
supposed to rebuild what's been done before? In most cases it makes
more sense to have the DBMS cache the data than to cache them on your
side. Funny... Or is it sort of homework? Not that I mind, I am just
curious.
Regards,
Nico
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
[Non-text portions of this message have been removed]
