• C++ Programming for Financial Engineering
    Highly recommended by thousands of MFE students. Covers essential C++ topics with applications to financial engineering. Learn more Join!
    Python for Finance with Intro to Data Science
    Gain practical understanding of Python to read, understand, and write professional Python code for your first day on the job. Learn more Join!
    An Intuition-Based Options Primer for FE
    Ideal for entry level positions interviews and graduate studies, specializing in options trading arbitrage and options valuation models. Learn more Join!

Seeking advice regarding buying a new workstation

sak

Joined
8/16/09
Messages
84
Points
18
Hey guys, I am going to use microsoft sql server for tick data manipulation. But I don't want to spend $3000 for buying some exotic workstation. However, I do need something more than regular PC. What kind of configuration do you recommend ? Currently I have a quad core, 8MB laptop and it often freezes when my query gets complicated.
 
I would recommend not using SQL Server. There are several possibilities for alternatives, ranging from NoSQL (Mongo, Redis) to traditional OSS SQL (Postgres) to ad hoc (serial C structs read using Python glue).

The main things you'd want in a server are memory (16 GB+) and fast network connection. These are typically the bottlenecks. If you want multiple independent queries, could help to go highly multicore, but are you really going to have 16+ independent queries?
 
Back
Top