Mailing List Archive: 49091 messages
  • Home
  • Script library
  • AltME Archive
  • Mailing list
  • Articles Index
  • Site search

[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 --