i7-9800x max ram support

[Dovi770]

hi
i need to build a system for big excel files.
i curently use i7 7th gen and 32GB ram, and it is just stuck after 40 seconds
the files is dozens of GB (10-50GB)
as of today, i need a lot of ram and best cpu single core performance as possible
i think about CPU i7-9800x (the different between 9th and 10th gen is minor) on Asrock X299 extreme 4 and 256GB ram (8X32GB)
my questions is, do i7-9800x actually support 256 ram?
any other option?

just a note, i'm not working on this, the account manager is.
ideas like "try open office/linux" etc won't work. the is what she need, she wont change how she work and not going to learn new softwares now
one day she will, but not today
i'm thinking for storage 2X Crucial MX500 2TB SSD. maybe 2 NVME drives? for raid 1

thank you!

[Meganter]

6 minutes ago, Dovi770 said:

 

Hello,

 

No it does not : https://ark.intel.com/content/www/us/en/ark/products/189122/intel-core-i7-9800x-x-series-processor-16-5m-cache-up-to-4-50-ghz.html 128GB max.

[Drama Lama]

5 minutes ago, Dovi770 said:

my questions is, do i7-9800x actually support 256 ram?

To my knowledge no

[Dovi770]

on the X299 platform, which CPU will support 256RAM?
or do i hav to buy actual server?
i do need fast single core cpu

[X-System]

@Dovi770 Core i9-10900X / 10920X / 10940X / 10980XE support 256GB

[Haro]

11 minutes ago, Dovi770 said:

on the X299 platform, which CPU will support 256RAM

10th gen 

The imc got a nice bump and it supports up to 256 gigs 

[Dovi770]

thank you!

[HM-2]

Issue might well not be RAM at all but Excel itself; handling of XLS/XLSX files above about ~300mb in my experience is an absolutely terrible, crash-strewn mess regardless of the performance of the platform you're attempting to do it on. Is there any reason why you're messing around with multiple-GB Excel files? There must be a better/easier/more coherent way of storing the data.

[Dovi770]

On 7/2/2020 at 1:59 PM, HM-2 said:

Issue might well not be RAM at all but Excel itself; handling of XLS/XLSX files above about ~300mb in my experience is an absolutely terrible, crash-strewn mess regardless of the performance of the platform you're attempting to do it on. Is there any reason why you're messing around with multiple-GB Excel files? There must be a better/easier/more coherent way of storing the data.

Currently we're trying to handle csv's with pandas and it is still RAM consuming issue. Is there an easier way to handle those files other than using dedicated programming (like C, RUST) or RAM increase?

[HM-2]

1 hour ago, Dovi770 said:

Currently we're trying to handle csv's with pandas and it is still RAM consuming issue. Is there an easier way to handle those files other than using dedicated programming (like C, RUST) or RAM increase?

Handle in what way? Massive CSVs and similar data sets become much more manageable when ingested into SQL databases or the like. Especially if the entire data set isn't being regularly rewritten and remains largely static or is just incrementally added to.

 

In $DayJob we routinely work with 20 or so CSV files per system in a network, ranging in size from a few KB to upwards of 20MB, for maybe 10-15,000 unique systems a time. Per day. In a single database. Sometimes we'll have over a week's worth of data before we age off. Using something like MySQL Query Browser for data interrogation and extraction is infinitesimally easier than dealing with these files on their own, and much faster than dealing with even single~200Mb+ firewall logs or similar data sets in single CSV files.