Re: How Big is Big enough

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 22 Nov 1999 22:13:39 -0000
Message-ID: <943308913.22201.0.nnrp-12.9e984b29@news.demon.co.uk>

See Connor McDonald's reply.

Using an Index Organised table, though
your get 2^N logical I/Os for N rows in the table.

I tend to estimate 10,000 logical I/Os
per 100MHz of CPU

From which (using very lazy estimates)
40 rows => 1 year.
75 rows => 2 ^ 35 years

        2 ^ 30 is about 10 ^9,
        2 ^ 35 is about 35 Billion years.

which I think is around the end of the
universe.

For your retirement, aim for 44 or 45 rows, unless you want to factor in MTBF and/or rates of improvement of hardware.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

ole c meldahl wrote in message <383916D4.3E05413B_at_statoil.com>...
>Jonathan Lewis wrote:
>
>> Personally I reckon that 40 rows will do for
>> a query to last a 600 MHz CPU for about
>> a year, and 75 rows should be enough to
>> keep it running until the heat death of the universe.
>
>Interesting! Could you give me the specifics of your computations so I
>can interpolate the number of rows necessarry to keep the query going
>about 40 years. I need somthing to keep me occupied until I retire;-)
Received on Mon Nov 22 1999 - 16:13:39 CST