First I am an AMD user and do not play games. I am looking to build a dedicated systems for analyzing large files of sock information as well as be able to monitor and trade stocks live. I tried using Access but I exceeded the database record limit with less than 2 years of data for one symbol and I have over 15 years of data for some symbols.
My plan is to use MySQL server for the databases and Python or R to crunch the numbers and do the analysis. A few months ago I saw an article that talks about CPU's and that some are more oriented to workstation / data processing and others are more oriented toward gaming. I can't find the article now. This will be a single user system dedicated to trading.
This may be my opportunity to finally convert completely to Linux.
My primary question is which AMD CPU would be best along with a very reliable Mother Board. (Asus, Asrock or MSI) that is stable for Linux. I am thinking that 16 GB of RAM will be adequate but I am open to more if justified. I will definitely buy another Noctua CPU cooler. I have one on my FX 8350 and it is so quiet and the CPU rarely gets above 39 degrees Celsius. I want a large SSD for my primary hard disk and look at 4 or 8 TB Seagate Iron Wolf series drives for data storage. I have had very good luck with these drives in my file server and they are virtually silent drives. I will need to size the power supply to handle up to 3 7200 RPM SATA drives.
Graphics are another issue since I am not a gamer I don't know very much about graphics cards and monitors. I would like to be able to connect 3 or 4 monitors. I will be displaying the data graphically to see if there are patterns. I am thinking of a large ips monitor ( up to 42" ) in portrait mode and possibly curved. That may be enough display space but I want to be able to add more if needed. I am looking for crisp lines and characters for the display. What resolution will I need considering how close I am to the monitor sitting at a desk looking up at the monitor in portrait mode.
Overall, I build machines that have the ability to grow with my applications and last a minimum of 5 years. My media server is running UnRaid for13 years without a hiccup. My windows machine is at least 5 years old.
The easiest solution is just buy the most expensive everything but I strive to build machines that fit the application. I don't mind spending the money if it is justified.
I would love to hear everyone's thoughts and recommendations.
My plan is to use MySQL server for the databases and Python or R to crunch the numbers and do the analysis. A few months ago I saw an article that talks about CPU's and that some are more oriented to workstation / data processing and others are more oriented toward gaming. I can't find the article now. This will be a single user system dedicated to trading.
This may be my opportunity to finally convert completely to Linux.
My primary question is which AMD CPU would be best along with a very reliable Mother Board. (Asus, Asrock or MSI) that is stable for Linux. I am thinking that 16 GB of RAM will be adequate but I am open to more if justified. I will definitely buy another Noctua CPU cooler. I have one on my FX 8350 and it is so quiet and the CPU rarely gets above 39 degrees Celsius. I want a large SSD for my primary hard disk and look at 4 or 8 TB Seagate Iron Wolf series drives for data storage. I have had very good luck with these drives in my file server and they are virtually silent drives. I will need to size the power supply to handle up to 3 7200 RPM SATA drives.
Graphics are another issue since I am not a gamer I don't know very much about graphics cards and monitors. I would like to be able to connect 3 or 4 monitors. I will be displaying the data graphically to see if there are patterns. I am thinking of a large ips monitor ( up to 42" ) in portrait mode and possibly curved. That may be enough display space but I want to be able to add more if needed. I am looking for crisp lines and characters for the display. What resolution will I need considering how close I am to the monitor sitting at a desk looking up at the monitor in portrait mode.
Overall, I build machines that have the ability to grow with my applications and last a minimum of 5 years. My media server is running UnRaid for13 years without a hiccup. My windows machine is at least 5 years old.
The easiest solution is just buy the most expensive everything but I strive to build machines that fit the application. I don't mind spending the money if it is justified.
I would love to hear everyone's thoughts and recommendations.