Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Date's First Great Blunder

Re: Date's First Great Blunder

From: Anthony W. Youngman <wol_at_thewolery.demon.co.uk>
Date: Fri, 23 Apr 2004 19:27:26 +0100
Message-ID: <i$zPE9KOAWiAFwMf@thewolery.demon.co.uk>


In message <c6b60a$fu1$1_at_news.netins.net>, Dawn M. Wolthuis <dwolt_at_tincat-group.com> writes
>While it seems to me that the PICK model is much more flexible (but I don't
>have evidence to prove that), I will grant that all of the systems I have
>seen that use the model are mid-range in size. I suspect that when you need
>to scale beyond the millions to the billions of stored "records" in one
>"file" you might be out of the PICK league. I'll have to ask some pickies
>about scaling up. I'm more inclined to think that recent approaches to
>scale, such as clustering, might apply to the big guys where PICK might be
>left in the dust on newer scaling techniques.

Most implementations of Pick don't really like individual "tables" over 2Gb in size. Actually, most current implementations have had that problem fixed, but it can be a pain to upgrade to a new version, and also a pain if you hit the barrier before you convert!

Cheers,
Wol

-- 
Anthony W. Youngman - wol at thewolery dot demon dot co dot uk
HEX wondered how much he should tell the Wizards. He felt it would not be a
good idea to burden them with too much input. Hex always thought of his reports
as Lies-to-People.
The Science of Discworld : (c) Terry Pratchett 1999
Received on Fri Apr 23 2004 - 13:27:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US