Wow! That explains why MUMPS is so much faster then the old KFAM I cut my teeth on - AND why MUMPS won a "shoot-out" I set up between it and the Pick operating system in the 80's(anyone remember Dick Pick?). I think my memory is correct that $O sorted 100,000 records in less than a minute and Pick was still going after 30 min.
Now for the real question - where does SQL fall in this multi-way B-tree hierarchy? Thanks, thurman > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:hardhats- > [EMAIL PROTECTED] On Behalf Of Chris Richardson > Sent: Thursday, April 14, 2005 10:19 PM > To: hardhats-members@lists.sourceforge.net > Subject: Re: [Hardhats-members] BIG NEWS re HealtheVet- St. Petersburg Tim > es > > Actually there is. > > Most MUMPS implementations are multi-way B-trees. Real true B-trees > suffer badly in real-life, nearly every action is a pointer split. The > performance of MUMPS sparse arrays is in the shared buffer pools and broad > pointer structures that get you to any data location in a 1,000,000 > element > database in 7 physical disk accesses or less. > > Best wishes; Chris > > ----- Original Message ----- > From: "Thurman Pedigo" <[EMAIL PROTECTED]> > To: <hardhats-members@lists.sourceforge.net> > Sent: Thursday, April 14, 2005 7:26 PM > Subject: RE: [Hardhats-members] BIG NEWS re HealtheVet- St. Petersburg Tim > es > > > > Back to Donald E. Knuth eh? One would think that by now... Guess there > isn't > > much new under the Sun. ..tx/t > > > > > -----Original Message----- > > > From: [EMAIL PROTECTED] [mailto:hardhats- > > > [EMAIL PROTECTED] On Behalf Of Greg Woodhouse > > > Sent: Thursday, April 14, 2005 6:14 PM > > > To: hardhats-members@lists.sourceforge.net > > > Subject: Re: [Hardhats-members] BIG NEWS re HealtheVet- St. Petersburg > Tim > > > es > > > > > > Of course, when you really get down to basics, it's all B-trees, > > > whether you're talking about MUMPS or your favorite RDBMS. > > > s-members > > > > > > > > ------------------------------------------------------- > > SF email is sponsored by - The IT Product Guide > > Read honest & candid reviews on hundreds of IT Products from real users. > > Discover which products truly live up to the hype. Start reading now. > > http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click > > _______________________________________________ > > Hardhats-members mailing list > > Hardhats-members@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/hardhats-members > > > > > > > > > ------------------------------------------------------- > SF email is sponsored by - The IT Product Guide > Read honest & candid reviews on hundreds of IT Products from real users. > Discover which products truly live up to the hype. Start reading now. > http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click > _______________________________________________ > Hardhats-members mailing list > Hardhats-members@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/hardhats-members ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members
