[dedwards11]

Hey guys,

I work long hours +12 and enjoy gaming in my free time.

I'm planning to build a desktop that will satisfy me for quite a while and did research on the individual components.

Motherboard: Intel DZ87KLT-75K
CPU: Intel Core i7 3970x
Graphics Card: nVidia GeForce GTX 770
RAM: G. Skill RipJaws-X 16GB (2x8GB)
SSD: Corsair Force Series GS 240 GB
HDD: WD 1TB Desktop SATA Hard Drive - OEM - Green
CD/DVD: Pioneer DVR-S20LBK 24x SATA Internal DVDRW
Case: Cooler Master HAF X USB 3.0 XL ATX Case

Can anyone tell me if these components are compatible with the case / each other?

Also could someone please recommend an appropriate power source?

Thanks a lot!

[Advertisements]

Gday dedwards11,
I think we can optimize your selection some as the CPU is a little overkill even for a top end gaming build.
In which country will you be buying your parts? if the US, please give your ZIP code.
What kind of display are you going to use?
You have not included an OS.

[iammykyl]

Gday dedwards11,
I think we can optimize your selection some as the CPU is a little overkill even for a top end gaming build.
In which country will you be buying your parts? if the US, please give your ZIP code.
What kind of display are you going to use?
You have not included an OS.

[dedwards11]

Thanks for replying,

I'd like to use Windows 8.1 as the OS and so far I'm thinking NEC MultiSync EA244WMi for the monitor.

About the build, I don't have much of a budget (5,000 USD I guess).

Like I said I work from home 12+ hours - the type of work I do is heavy database management that often causes minutes of waiting time on my current setup.

What would you recommend?

P.S. I Iive in London, UK

[iammykyl]

Gday.
Thanks for the update. Looks like you may need more of a workstation with decent gaming coming second. You have a pretty decent budget.
Please list the software you use and if possible the type of database you manipulate and a rough workflow.

[dedwards11]

Okay that sounds like a good direction.

Basically I handle quite a lot of delicate data in SQL through tools such as:

Navicat
PhpMyAdmin
HeidiSQL

I use Excel approximately 5 hours out of my workday, I know it may seem like that would be insignificant but actually my excel work is heavily macro based and each operation I do does about 10 things across 10 files all at once.

I frequently end up having to wait while my processors freak out about an extended lookup or whatnot (attached a screenshot).

At the moment, even though I think my current setup is quite okay, I've resorted to going to task manager and setting priority to realtime which speeds the application up but basically kills the rest of the system.

Thanks again for your help!

Attached Thumbnails

• 

[dedwards11]

Is this any good?

http://www.custompcr...ust-2013/18444/

If so I guess we could just see if we could improve it while keeping it under 5k?

[iammykyl]

Gday.
The CPCR build is geared to much towards gaming (GPU overkill, CPU to weak, storage is not optimized) and for you, should be geared towards a workstation.

Which of these are you using for NavIcat? MySQL, MariaDB, Oracle, SQLite, PostgreSQL, Microsoft SQL Server.
How big is your Data Base?

What CPU are you using now?
How many HDDs are you using?
If any RAID, are you using the MB controller or a card.
What kind, and where are your backups stored.

When working, do you often have to switch between open windows, say from two applications running together? Or need tools for an application open at all times.?

[dedwards11]

I use Navicat for MySQL - database sizes tend to fluctuate depending on clients. (Biggest client to date had a db of approximately 4 billion records)

I don't have RAID in current set up and I'm using two 1TB HDDs, one to work off of and one for backup storage + videos, pictures, music etc.

I'm away for the weekend and shamefully don't even know what CPU is in my PC other than that it is by Intel....

Luckily my work doesn't require me to backup entire DBs usually just outputs of specific queries so my "backups" are generally in CSV files.

When working I'm usually using multiple applications and switching between them quite often,

Thanks for taking the time to look into my bizarre PC requirements...

[iammykyl]

Gday.
Just about there, working out how many HDDs you require, so a few questions as I don't want to over provision.
You don't actually run your own Data base server?
Your don't work directly on a client's server?
You log onto your client's server and import a Data base to a folder on your computer to modify/work on?
You save the modified Data to a folder on you computer?
You export the modified Data back to the client's server?

Do you use the import/export wizards? see link.
Can you specify the location where the import from the server is to be saved?
When you have completed your work, can you specify a save location, before uploading to the client"s server?

Do you have an external backup drive that you can use with the new build?

Your Budget. $5000, converted £3000.

https://docs.google....icat_mac_en.pdf

[dedwards11]

Hi,

Yes I download dbs from clients and work on them locally to identify key segments of their data.

I do save the modified data on to my computer and back it up on external HDDs.

I don't use wizards for import/export the reason being that usually each client has very different DB formats and then requires very different output formats. (Im sure that not using wizards is probably more of an oversight on my part and I will proably use them in the future)

I do have an external HDD to use for the build: WD My Passport Ultra 1TB

Finally, yes I can specify save location on upload/download.

Glad to hear we're nearly there you've been so helpful this far!

[iammykyl]

Gday dedwards11.
This system will meet your requirements and has options for upgrading/expanding should the need arise.

Your build, > http://uk.pcpartpicker.com/p/3cxu5
Some reasons for hardware choices.

Importance of CPU cache, pages 20/24 > https://docs.google....dware-ebook.pdf
CPU performance, > http://extremespec.n...ng-performance/

With the X79 MBs gone for the most featured /upgrade path, for the money.
> http://www.hardocp.c.../1#.UylhJaiSyi5
> https://www.asus.com...ards/X79DELUXE/

GPU, GTX 760 would do all you need, (discuss)

Storage.
250GB EVO SSD, for OS/Programs.
120 EVO SSD, Import from Server.
1TB HDD, Save of precessed DATA.
1TB HDD, Personal folder, like, my music/videos, Games.
> http://uk.hardware.i...e-series-tested!

Monitor. Your selected had some poor Pro/user reviews, so changed.
> http://www.kitguru.n...nitor-review/2/

Cooler,
Specs/compatibility, > http://www.noctua.at...ts_id=41&lng=en

PSU. More than you actually need but allows for upgrade, more monitors, HDDs, TV tuner, etc.
Changed the case, tell us what you think.

[dedwards11]

Thanks a lot this looks great would it fit in this case?:

http://www.amazon.co...AKW/cupcre06-20

[iammykyl]

Gday.
Yes, the case will take your system a couple of things to note, the fan controller does not allow individual fan control, the font IEEE 1394 port will not be usable as the MB does not have a header, to enable the front USB 3.0 port, you have to use a pass through cable and plug into the USB port on the back I/O, (image on page 5 of the review) A little limiting for HDD expansion, only has six and you will be using four.
> http://www.legitrevi...ase-review_1597

Adjusted the parts list, changed the case, removed the extra case fan.

Updated parts list, > http://uk.pcpartpicker.com/p/3d72k


Taking another look at the monitor, The selected is excellent, but perhaps a bit 'too good' for your needs as it is aimed at photo editing.

Edit, add more info about the case.

[iammykyl]

Gday.
two very good monitors to look at, a bit cheaper thanthe selected one but will still do the job for your.

> Dell U2412M £209.99 > Review, http://www.tftcentral.co.uk/reviews/dell_u2412m.htm
> Asus PB248Q £287.50 > Review,http://www.tftcentral.co.uk/reviews/asus_pa248q.htm

are you still looking at different cases?

[dedwards11]

Thanks so much for all your help - this is an epic service and you guys should be proud!

 

Thanks for the suggestions on monitors it would be good to lower the cost a bit but I really would like something that I could hook up to a playstation or something if need be (preferably through HDMI)

 

As for cases, yes I'm still looking I'm leaning heavily to the white one (http://www.amazon.co...AKW/cupcre06-20) simply because of looks.

 

I'm going to be staring at this thing quite often want it to look great