Re: Datawarehouse Load Performance?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 7 Feb 2000 19:00:07 -0000
Message-ID: <949950509.928.2.nnrp-07.9e984b29@news.demon.co.uk>

Highly variable as you say, but I would be looking for less than 2 hours as a
starting point for 1.2M rows.

I'm local to you if you need a couple of days consultancy

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

Stephen Darlington wrote in message <87m7jn$6b7_at_romeo.logica.co.uk>...
>I'm just starting to design a datawarehouse load and was beginning to get a
>little worried about the performance.
>
>What are other people's experience loading a datawarehouse? We're using 8i
>on a 4 processor (Xeon, 550Mhz) NT box and are looking to process around
1.2
>million rows. Some very rough metrics indicated that this could take a week
>to load!
>
>I appreciate that there are too many variables here to get a very precice
>answer, but I'd like to hear any experiences you have.
>
>Cheers,
>--> Stephen
>---------------------------------------------------------------
> Stephen Darlington (http://www.zx81.org.uk)
> "Never put a sock in a toaster"
>---------------------------------------------------------------
>
>
Received on Mon Feb 07 2000 - 13:00:07 CST