Re: Question on IO consideration
Date: Wed, 22 Sep 2021 17:40:07 -0400
Message-ID: <8dd2dcf0-85c6-a0c2-446d-654ac4ce4186_at_gmail.com>
Yes, I know. Cache is columnar and it somewhat speeds things up.
However, to fully utilize columnar features, one needs In-Memory
option. And that's expensive.
Regards
On 9/22/21 03:51, Ghassan Salem wrote:
> Mladen,
> The feature Tanel is mentioning is free, not to be confused with
> in-memory flashcache, which requires the inmemory option.
>
> Regards
>
> On Wed, Sep 22, 2021 at 1:59 AM Mladen Gogala
> <gogala.mladen_at_gmail.com> wrote:
>
>
> On 9/21/21 17:41, Tanel Poder wrote:
> > Exadata storage cells (starting from cellsrv v12.1.2.1.0 / Jan
> 2015)
> > can use fully columnar flash cache for greatly speeding up reads
> (the
> > cache is fully columnar, not hybrid like the datafile storage).
>
>
> And all they want in exchange for that capability is your first-born.
> Bargain price, indeed. BTW, MariaDB can also do that, a bit cheaper.
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217
> https://dbwhisperer.wordpress.com
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 22 2021 - 23:40:07 CEST