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.
Seeking advice regarding buying a new workstation
- Thread starter sak
- Start date
- Joined
- 5/23/13
- Messages
- 795
- Points
- 73
use ur company's cluster
Yike Lu
Finder of biased coins.
- Joined
- 5/10/10
- Messages
- 772
- Points
- 53
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?
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?
- Joined
- 5/2/06
- Messages
- 12,164
- Points
- 273
Where is your data located? You can rent computing resources from Google/Amazon and pay by the hour.
