Datawarehouse Load Performance?

From: Stephen Darlington <stephen_at_zx81.org.uk.nospam>
Date: Mon, 7 Feb 2000 10:42:57 -0000
Message-ID: <87m7jn$6b7@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 - 04:42:57 CST