[REBOL] Re: KDB was {Re: Re: dbms3.r 0}
From: g:santilli:tiscalinet:it at: 17-Jan-2002 21:31
Hello Jason!
On 15-Gen-02, you wrote:
JC> <quote>
JC> Why is Kdb so fast?
JC> The main reason is that Kdb tables are "inverted", i.e. the
JC> data in each column is stored together, instead of in the row
JC> orientation used by most RDBMS's. The column data is also
JC> organized for optimal processing speed. </quote>
Well, that's like having all columns indexed. It's nice when
you'll be searching an all columns with the same frequencies, I'm
not sure in other cases (in paticular, inserts and updates will be
much slower).
Regards,
Gabriele.
--
Gabriele Santilli <[giesse--writeme--com]> - Amigan - REBOL programmer
Amiga Group Italia sez. L'Aquila -- http://www.amyresource.it/AGI/