Hi All,

Yes, anyone can design a load system so badly that it takes a long time.....it's not the databases fault...

I recently did an Oracle ODS based on Sybase IWS which is all dimensional so remember we had to perform lookups of all keys etc...we had around 180M rows inserted per day and 120M updated....we had numerous dimension tables with 20M+ rows in them....

We could run that volume of inserts in 8 hours on only 8 CPUs. No problem...

Interestingly, we invented (or so it seems) the ability to implement linear scalability in the DataStage engine....

So, if we can thrown 180M rows into oracle in 8 hours on only 8 CPUs most companies are going to have less data than that....this was for a telco in a country with a population of 20M......and few organizations have more data than telcos.....

Peter