Re: Specifying all biz rules in relational data

From: Laconic2 <laconic2_at_comcast.net>
Date: Wed, 22 Sep 2004 09:04:32 -0400
Message-ID: <WNudnU0aDp3j5czcRVn-vQ@comcast.com>

"Laconic2" <laconic2_at_comcast.net> wrote in message news:yNKdnZlKDaZodc3cRVn-qQ_at_comcast.com...
> Yes but reading and writing 10 million rows in a data warehouse is a piece
> of cake.

I'm backing off from this one. It's not a piece of cake. It's more like an overnight batch job.

You need a server that will process about 3,000 rows per second. That's a little over a million rows an hour.
In about 10 hours, you'll be done with 10 million rows.

3,000 rows per second is definitely feasible, with a reasonable amount of hardware, a competent DBMS, exclusive access, and a well designed database. Received on Wed Sep 22 2004 - 08:04:32 CDT