High end CPU performance

Toggle sidebar Toggle sidebar
M

MikaK

Reputable
Mar 6, 2014
5
0
4,510
I am a professional poker player and use a statistical analysis tools which provides real time data on the tendencies of my opponents based on thousands of hands played. I use several other tools which all use access to the same database of players and the hands played by them. When playing against many opponents my computer starts lagging and it greatly affects my productivity.

Right now I am using H87-PRO + Intel i7-4770K(overclocked) + Corsair H60i + 1 SSD drive and if all my tools are running the CPU is on 97-100% all of the time.

My budget is around 3-4k.

- Do i need SSDs in Raid to increase performance by separating my Database, Os, Tools etc? Is the difference somehow noticable?
- Dual CPU, i7 extreme vs Xeon, best option for performance
- Is multi-processor server system feasible?

Budget is up to 5k$ for motherboard, cpu, cooling and probably ill need new psu.

Thanks!
 
Solution
HiTechObsessed
The 4960x is binned higher, which *generally* means it can overclock better. Considering his budget of $5k and desire to maximize CPU performance, I recommended the Extreme edition.
Sort by date Sort by votes
HiTechObsessed

HiTechObsessed

Splendid
Dec 3, 2013
5,430
0
24,960
You don't want a database running off an SSD. 10k RPM HDDs in RAID would be your best bet, and the hexacore i7 overclocked will give you the best performance. Overclock this thing and watch the magic happen!

PCPartPicker part list / Price breakdown by merchant / Benchmarks

CPU: Intel Core i7-4960X Extreme Edition 3.6GHz 6-Core Processor ($1034.98 @ SuperBiiz)
CPU Cooler: Corsair H110 94.0 CFM Liquid CPU Cooler ($109.99 @ Amazon)
Motherboard: Gigabyte GA-X79-UP4 ATX LGA2011 Motherboard ($229.99 @ Microcenter)
Storage: Samsung 840 Pro Series 256GB 2.5" Solid State Disk ($205.99 @ Amazon)
Storage: Western Digital VelociRaptor 250GB 3.5" 10000RPM Internal Hard Drive ($92.98 @ SuperBiiz)
Storage: Western Digital VelociRaptor 250GB 3.5" 10000RPM Internal Hard Drive ($92.98 @ SuperBiiz)
Storage: Western Digital VelociRaptor 250GB 3.5" 10000RPM Internal Hard Drive ($92.98 @ SuperBiiz)
Storage: Western Digital VelociRaptor 250GB 3.5" 10000RPM Internal Hard Drive ($92.98 @ SuperBiiz)
Total: $1952.87
(Prices include shipping, taxes, and discounts when available.)
(Generated by PCPartPicker 2014-03-06 14:40 EST-0500)

And I brought up the SSD being bad for database because writing a lot of tiny data to it over and over and over decreases its life expectancy. If you're fine with replacing SSDs more often than normal, then by all means, setup your database on some RAID 0 SSDs lol
 
Upvote 0 Downvote
M

MikaK

Reputable
Mar 6, 2014
5
0
4,510
What about Dual CPU system. I guess the performance is not doubled compared to a single CPU system, but how much on average the productivity increases?

 
Upvote 0 Downvote
D

Deuce65

Honorable
Oct 16, 2013
1,465
0
11,960
Wow, lots of disinformation here.
With the information you have provided no one can answer your question correctly.
First, what program are you using? The program itself should have documentation that tells you what type of database it is, and how it has been optimized. Without that information, every answer you get is largely a guess.
Second, how large is the database?
Third, what hardware\software do you currently have? ALL of it; your list there for example doesn't say what drives you have, what memory, your OS, etc.
Fourth, you're dealing with a database program. Not trying to put anyone here down or anything, but we don't know anything about the database you are using or how large it is; anyone that tells you they know exactly what hardware you need (which they couldn't possibly know since they don't know your requirements) is worse than someone who doesn't know anything because they'll send you off to spend thousands of dollars on hardware that won't help you.
 
Upvote 0 Downvote
M

MikaK

Reputable
Mar 6, 2014
5
0
4,510
@Deuce65

The database is PostgreSQL and is around 300GB. Only one of my applications is actually writing/modifying it, but 2 separate custom build tools are reading from it. I understand that my tools are not optimized correctly, but there isn't much my developer can do...

What these tools do is, they open more than 100 poker tables on several different poker rooms and using scraping identifies who is playing and compares it to my DB and based on certain filters notifies me. The problem is not necessary the DB, that is why i was focusing on CPU speed.


 
Upvote 0 Downvote
You must log in or register to reply here.

TRENDING THREADS

Latest posts

Moderators online

Share this page

COMPANY
RESOURCES
FOLLOW
Top Bottom