Intel Xeon E5 or i7 7700

[hhchenfx]

Hi Everyone,

I am about to buy new PC. My work is mostly on:

- Proc SQL and transpose to transform the data

- analyze a timeseries record by record to see how the series perform, such as which period it go up and what period it go down longest.

However, the data is quite large and I have to run thought many dataset so it take long time to complete the job.

My question is that, with that nature of work, should I buy server with Intel Xeon E5 kind of machine (with 64G RAM)or buy PC with i7 7700 (with 32G Ram).

Thank you for your help.

HHCFX

[LinusH]

Hard to tell with this little info.

First step to monitor your jobs on the existing computer, and see if you are CPU, RAM och I/O bound.

CPU is usually the least utilized in SAS, but I'm unsure about time series calculations...

Statistics, sorts and SQL joins usually likes lot's of RAM, so you don't have to page to disk during processing.

Fast disks will always be a good investments, SSD prefererad nowadays I think.

[hhchenfx]

Currently, I use the i7 3770 with 32G ram.

Sometime it use up to 30G Ram.

By the way, what is IO means?

[ChrisNZ]

IO means InputOutput, in other word, disk access.

Ensure that you have really fast storage, it's much more important than CPU on most cases.

On a PC, that's Solid State Drives hooked to the PCIe bus, such as M.2 or NVMe. Not SATA.

[LinusH · Accepted solution]

Input / output operations, in other words, reading from /writing to disk.
If you are currently utilizing 30GB you will probable benefit from a 64GB setup.