Jump to content
Search In
  • More options...
Find results that contain...
Find results in...

parts justified for 2700x

Hi Guys,
I have just built my first PC and the performance is amazing but it does not solve my real purpose of getting this built. I work with huge excel files with million rows that use vlookup and sumifs and hybrid of count and if functions. The reason for getting this PC was to get the work done faster but i am not getting much difference coming from a dual core I5 and 4 gb ram. My new build has:

Ryzen 2700x
B450M Mortar
8 GB 2666 MHZ g.skill ripjaw Vseries
240gb WD green M.2 SSD
Nvedia 710 2GB graphics card
Gigabyte 500W bronze certified PSU


I have overclocked the processor to 4.15 mhz however the ram cannot be overclocked. I notice a HUGE difference in performance from my previous laptop but i don't notice much difference in the excel calculation speeds which is the real reason this PC was built. Although I don't plan on using this PC for anything other than a workstation but i want the 2700x to run at its full efficiency after spending all that money. 
Can anyone see a bottleneck anywhere which is most likely to slow down excel calculations or the PC in general. I can still exchange the parts. I don't plan on playing games or video editing so don't require a graphics card. Any recommendations will be helpful. Thanks
Varun

Link to comment
Share on other sites

Link to post
Share on other sites

maybe, just maybe pick up more ram? i'm not certain that will solve the problem, but it should help for the CPU. and ryzen likes fast ram, 3000mhz if possible. 

 

but is excel on the SSD or a hard drive?

Rig 1: i7-9700k OC'd to 5.0ghz all core | EVGA XC RTX 2080Ti | ADATA DDR4 2400mhz 4x8gb | ASUS PRIME Z370-P | Asetek 550LC 120mm | ADATA 480GB SSD & Toshiba P300 3TB | Cooler Master Masterbox MB500 | Win 10 Home | Logitech G910 Orion Spectrum, G502 Proteus Spectrum, G933 Artemis Spectrum Snow Wireless Limited Edition, Corsair MM300 Mouse Pad | 2 MSI Optix Curved 27" FHD Monitors 

 

(before i sold the WD drive and MSI gpu - https://www.userbenchmark.com/UserRun/11946219 171 gaming. felt good.)

 

Rig 2: i7-7700k Stock clocks | MSI Armor GTX 1070 | ADATA DDR4 2400mhz 2x8GB | MSI Z270 A-Pro | WD Green 240GB SSD & 2TB Seagate HDD | Thermaltake Core G21 Tempered Glass Edition | Win 10 Home | 2 HP Omen FHD 144hz 24.5" Monitors 

 

Rig 3: i7-6700 | GT 730 & GT 645 OEM | Some random DDR4 2133mhz 2x8gb sticks | OEM Dell Mobo | WD Black 2TB HDD & Toshiba 1TB HDD | Win 10 Home | 3 27" Dell FHD Monitors 

 

Rig 4: i7-4770 | EVGA SSC 1050ti | Some random DDR3 ram 2x2gb and 2x4gb sticks | OEM Dell Mobo | Stock Cooler | 1TB WD Black HDD | Win 7 Home 

 

RIP 

 

Rig 5 (dead and dismantled and sold) : i7-7820X OC'd to 4.8ghz all core | MSI DUKE 1080ti | ADATA DDR4 2400mhz 4x8gb | Gigabyte X299 UD4 PRO | Asetek 240mm AIO | WD Green 240gb SSD | Other various components that I can't remember

 

Rig 6 (same fate as rig 5) i7-8700k stock clocks | MSI DUKE 1080ti | ADATA DDR4 2400mhz 2x8gb | MSI Z370 A-Pro | Asetek 550LC 120mm | WD Green 240GB SSD & Toshiba 2TB HDD | Other various components that I can't Remember 

Link to comment
Share on other sites

Link to post
Share on other sites

18 minutes ago, varunsonu said:

8 GB 2666 MHZ g.skill ripjaw Vseries

is this one stick or 2 sticks that are 4gb each? because that can be slowing you down dramatically. 

Rig 1: i7-9700k OC'd to 5.0ghz all core | EVGA XC RTX 2080Ti | ADATA DDR4 2400mhz 4x8gb | ASUS PRIME Z370-P | Asetek 550LC 120mm | ADATA 480GB SSD & Toshiba P300 3TB | Cooler Master Masterbox MB500 | Win 10 Home | Logitech G910 Orion Spectrum, G502 Proteus Spectrum, G933 Artemis Spectrum Snow Wireless Limited Edition, Corsair MM300 Mouse Pad | 2 MSI Optix Curved 27" FHD Monitors 

 

(before i sold the WD drive and MSI gpu - https://www.userbenchmark.com/UserRun/11946219 171 gaming. felt good.)

 

Rig 2: i7-7700k Stock clocks | MSI Armor GTX 1070 | ADATA DDR4 2400mhz 2x8GB | MSI Z270 A-Pro | WD Green 240GB SSD & 2TB Seagate HDD | Thermaltake Core G21 Tempered Glass Edition | Win 10 Home | 2 HP Omen FHD 144hz 24.5" Monitors 

 

Rig 3: i7-6700 | GT 730 & GT 645 OEM | Some random DDR4 2133mhz 2x8gb sticks | OEM Dell Mobo | WD Black 2TB HDD & Toshiba 1TB HDD | Win 10 Home | 3 27" Dell FHD Monitors 

 

Rig 4: i7-4770 | EVGA SSC 1050ti | Some random DDR3 ram 2x2gb and 2x4gb sticks | OEM Dell Mobo | Stock Cooler | 1TB WD Black HDD | Win 7 Home 

 

RIP 

 

Rig 5 (dead and dismantled and sold) : i7-7820X OC'd to 4.8ghz all core | MSI DUKE 1080ti | ADATA DDR4 2400mhz 4x8gb | Gigabyte X299 UD4 PRO | Asetek 240mm AIO | WD Green 240gb SSD | Other various components that I can't remember

 

Rig 6 (same fate as rig 5) i7-8700k stock clocks | MSI DUKE 1080ti | ADATA DDR4 2400mhz 2x8gb | MSI Z370 A-Pro | Asetek 550LC 120mm | WD Green 240GB SSD & Toshiba 2TB HDD | Other various components that I can't Remember 

Link to comment
Share on other sites

Link to post
Share on other sites

When you are working in excel how much RAM are you using? If the files are really big you are running into RAM limitations most likely and that is why it feels slow. When RAM is fully used it start using your hard drive and that creates a huge bottleneck. 

 

When I work in excel everything is lightning quick and I have an R7 1700 and 2x16GB of RAM. You probably need 16GB.

 

26 minutes ago, TH3R34P3R said:

is this one stick or 2 sticks that are 4gb each? because that can be slowing you down dramatically. 

Not being dual channel wouldn't make THAT much of a difference at all. OP is describing it as being as slow as his previous system with a dual core I5 and 4GB of RAM when using excel.

AMD Motherboard Tier List  GPU Cooling Tier List  PSU Tier List  A Dive Into Custom Keyboards & Mechanical Switches

NEWCOMERS Remember to ' Reply ' to comments in order for people to see them, this is done by clicking the arrow icon at the bottom of a comment (Quote).

My Builds:

MEGA Desk Build

 

Blueberry Pi  R9 3950X  Asus X470 ROG Crosshair VII Hero Wi-Fi ATX  Corsair Vengeance RGB Pro 4x16GB 3200MHz CL16  EVGA GTX 1080Ti SC Black Edition 11GB  EVGA P2 850W w/ Blue Sleeved Cables  Cryorig R1 Universal (Blue)  2x Corsair Force MP510 4TB w/ Asus Hyper m.2 V2  Corsair ML Pro Blue LED Fans  Fractal Design Meshify C TG ATX Mid Tower  

Asus ROG SWIFT PG348Q 100Hz IPS G-Sync UW  Dell UltraSharp U3419W 60Hz IPS UW  Custom TOFU96  Corsair Scimitar Pro RGB 

 

Work Rig  ThreadRipper 3970X  Asus Prime TRX40 Pro ATX  G.Skill RipjawsV 8x32GB 3200Mhz CL16  Nvidia Quadro RTX 6000 24GB  Corsair HXi 1000W  EVGA CLC 360 AIO  8x Sabrent Rocket 2TB w/ 2x Asus Hyper m.2 V2   Arctic P12 Fans  Phanteks P400A ATX Mid Tower 

 

Plotting Machine 1  ThreadRipper 2990WX  AsRock X399 Taichi ATX  Kingston HyperX Fury 8x16GB 2666Mhz CL18   Nvidia Quadro K600 1GB  Corsair RMx 850W  EVGA CLC 360 AIO ‖ 2x Sabrent Rocket 2TB & 2x Sabrent Rocket 4TB w/ Asus Hyper m.2 V2  Arctic P12 Fans  Rosewill RSV-L4500 4U  5x Dell DS60 60-bay JBOD w/ 1.2PB of HDD Storage  HP 22U Half Rack

 

Plotting Machine 2  R9 3950X  Asus TUF X570-Plus Wi-Fi ATX  G.Skill RipjawsV 4x16GB 3200Mhz CL16   Nvidia Quadro K600 1GB  Corsair RM 650W  Noctua NH-D15s Chormax ‖ 4x Corsair MP600 Force 1TB W/ Asus Hyper m.2 Gen4  Arctic P14 & P12 Fans  Silverstone FARA R1 ATX Mid Tower

 

J.A.R.V.I.S.  R9 3900XT  Asus B550-I ROG STRIX Wi-Fi ITX  G.Skill Ripjaws V 2x16GB 3600MHz CL16  EVGA GTX 1080 SC2 iCX 8GB  Corsair SF 750W Platinum  Corsair H100i Pro AIO  Noctua NF-A12x15 Chromax Fans  FormD T1 SFF ITX Case  

LG 75UM8070PUA 4K UHD 120Hz IPS HDR TV  Corsair K63 Cherry MX Red Special Edition Wireless  Corsair Ironclaw RGB Wireless

 

Archive Server  R3 2200G  Asus B450-I ROG STRIX Wi-Fi ITX  Corsair Vengeance RGB Pro 2x8GB 3200MHz CL16 White  Vega Integrated Graphics  EVGA P2 750W  Prism Wraith Cooler  ITX Open Bench  2x HP SAS Expander  LSI-SAS9211  220TB of HDD Storage

 

SFF ITX Home PC  i5-7500  MSI B250I Gaming Pro Wi-Fi AC ITX  G.Skill Ripjaws V 2x8GB 2800MHz  Intel Integrated Graphics  Seasonic SSP Flex ATX 300W PSU  Cryorig C7  Velka 3 rev 1.2 SFF ITX Case (Grey)  

 

Laptop  Dell XPS13 2-in-1 7390 (2020)  i7-1065G7  32GB 3733MHz LPDDR4x  Intel Integrated Graphics  1TB NVME M.2  UHD+ (3840 x 2400) InfinityEdge Touch Display 

 

Keyboard Collection  GMMK Full Size  TOFU96 90%  ‖ KBD8x MKII TKL ‖ Drop CTRL High Profile TKL ‖ KBD Bella 75% ‖ GMMK Pro 75% ‖ XD84 Pro 75%  KBD67 V2 MKII 65%  KBD67Lite 65%  TOFU65 65%  KBD Blade 60%  Drop Carina 60%  Southpaw75 60% w/ Left Numpad  OLKB Preonic V3 Ortholinear ‖ CosPad XD24  ‖ KBDPad MKII

 

Key Cap Collection  GMK Boba Fett  GMK Red Samurai  GMK Laser CyberDeck +Novalties  GMK Arch  MaxKey B&W  Drop MT3 Camillo ‖ Matt3o MT3 /dev/tty  KBDfans Biip Torii Ext-2048  ePBT Less But Better +Novalties  EnjoyPBT Dolch  WinMix Mustard  Drop Skylight Horizon & Slate ‖ Glorious Black Aura  

 

Mechanical Key Switch Collection  Zealios V2 65g  Zealios V2 78g ‖ Zilents V2 67g  Tealios V2 67g  C³ Kiwi ‖ C³ Tangerine  Invyr Holy Panda  Durock T1 67g  Kailh Box Thick Jades ‖ Kailh Box Royal ‖ Kailh Box Heavy Dark Yellow ‖ Kailh Box Heavy Burnt Orange  Kailh Box White  Kailh Box Red  Kailh Pro Purple  Kailh Pro Burgandy  Gateron Ink Black V2  Gateron Black  Gateron Yellow  Gateron Brown  Gateron Green  Gateron Blue ‖ Cherry MX Black ‖ Cherry MX Brown ‖ Cherry MX Red

Link to comment
Share on other sites

Link to post
Share on other sites

I only have 1 SSD 240 gb WD green m.2 so excel is on SSD and its 1x8gb 2666 mhz ram. I was thinking of getting the 8gbx2 trident z but it costs 210 USD in my country and i don't know if the speed boost will be enough value for money

Link to comment
Share on other sites

Link to post
Share on other sites

23 minutes ago, JM21 said:

When you are working in excel how much RAM are you using? If the files are really big you are running into RAM limitations most likely and that is why it feels slow. When RAM is fully used it start using your hard drive and that creates a huge bottleneck. 

 

When I work in excel everything is lightning quick and I have an R7 1700 and 2x16GB of RAM. You probably need 16GB.

 

Not being dual channel wouldn't make THAT much of a difference at all. OP is describing it as being as slow as his previous system with a dual core I5 and 4GB of RAM when using excel.

I am generally using 50% of my ram at any point. On rare occasions it jumps to 80%. I read somewhere that excel can only utilize 2gb of ram. It has limit of 2gb for some reason. My files dont go over 50mb. If the ram only seems to be the bottleneck then i will go for the upgrade. would the speed matter too much between 2666 mhz and 3200mhz?

Link to comment
Share on other sites

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share


×