Page 1 of 1

Hardware configuration

Posted: Tue Jun 02, 2009 6:44 am
by bikan
Hi All,

We are planning to load 10 to 12 Million record per night. I'm planning to have below Server configuration. Pls let me know will suit my
requirement? What should be the standard configuratio for loading 10 to 12 million records overnight?

4 CPU
4 GB RAM 1 GB per CPU
1 TB Hard Disk
.5TB Scratch Disk

Posted: Tue Jun 02, 2009 7:10 am
by chulett
Sorry, but there's no such thing as a 'standard configuration' and no way to tell you what hardware is needed to load X rows in Y hours. There's far too many variables in 'loading' data for that.

Posted: Tue Jun 02, 2009 7:13 am
by bikan
Agree with you.

But for a planning purpose is it Ok to prepare a machine with the given configuration?

Posted: Tue Jun 02, 2009 7:21 am
by chulett
Probably. For planning purposes. :wink:

Posted: Tue Jun 02, 2009 8:24 am
by ArndW
"records" and "rows" are meaningless by themselves. How many Mb or Gb must be transferred? What are you writing into and where are you reading from?