homepage Welcome to WebmasterWorld Guest from 54.167.144.202
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Hardware and OS Related Technologies / Webmaster Hardware
Forum Library, Charter, Moderator: open

Webmaster Hardware Forum

    
Best PC to buy for heavy database use?
TravelSite

10+ Year Member



 
Msg#: 3941274 posted 12:24 pm on Jun 26, 2009 (gmt 0)

I'm looking to buy a new pc that will be used mainly for doing lots of demanding database queries / stuff on (running MYSQL, probably XP, databases are several GB+). Don't need it for games.

Can anyone recommend what I should be looking for in order to carry out database queries in a reasonably quick time?

E.g. Does having a graphics card help at all? What size of RAM should I be looking at?

 

J_RaD

WebmasterWorld Senior Member 5+ Year Member



 
Msg#: 3941274 posted 1:42 pm on Jun 30, 2009 (gmt 0)

with large databases you'll want as much memory as you can afford

6 to 8 gigs would be a good place to start.
(you'll need a 64 bit OS to support that much ram NOT XP - windows 7 is out on pre-order)

also its all about access time, RAID 0 would be a good thing to have(but have good backups)

graphics card isn't going to do anything for you but pick up a cheap PCI-E cause an onboard is not very good and it will eat some of your system ram.

TravelSite

10+ Year Member



 
Msg#: 3941274 posted 8:57 am on Jul 2, 2009 (gmt 0)

Thanks for that :) I was wondering if a 64 bit OS would improve things - I'll hold off until Windows 7 arrives.

kaled

WebmasterWorld Senior Member kaled us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 3941274 posted 3:37 pm on Jul 2, 2009 (gmt 0)

If you are planning to use more than 3GB of memory, 64bit Windows is mandatory.

I'm not sure where the threshold is for Linux, but it is theoretically impossible to access more than 4GB of memory without a 64bit OS.

Kaled.

lammert

WebmasterWorld Senior Member lammert us a WebmasterWorld Top Contributor of All Time 5+ Year Member



 
Msg#: 3941274 posted 6:00 am on Jul 4, 2009 (gmt 0)

The memory limits page on the Microsoft website [msdn.microsoft.com] will show you that you can use more than 4GB physically memory effectively on many 32 bit versions of their operating systems. Even the old Windows 2000 Server OS is capable of addressing 32 GB in the Datacenter version.

The main problem is not addressing that amount of memory with a 32 bit OS. The 8 bit 8088 and 16 bit 8086 processors were already capable of addressing 1MB of memory with a 16 bit OS. The problem is that with the flat memory model most 32 bit programs are programmed in, that any process is only capable of addressing 4GB. With some memory reserved for accessing hardware like videocards, this leaves an effective 3GB per process.

But with the right 32bit Windows OS, you are capable of using more than 4GB physical memory, as long as it is divided over multiple processes:

3GB for the SQL database process
3GB as disk cache
etc.

tangor

WebmasterWorld Senior Member tangor us a WebmasterWorld Top Contributor of All Time 5+ Year Member Top Contributors Of The Month



 
Msg#: 3941274 posted 6:48 am on Jul 4, 2009 (gmt 0)

While 32 bit can be divided into effective use, those 3gb limits remain. Since this is a new machine do go with a new 64 bit OS and a large as you can do (affordably) the first time around. Saves heartache later when further hardware upgrades become necessary. And always remember that even though new hardware can help, bad coding practices and failure to streamline all functions can negate any advance in speed/capacity! (Been there, done that, learned the hard way!)

Frank_Rizzo

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 3941274 posted 10:09 am on Jul 4, 2009 (gmt 0)

O/S
I don't know about Windows 7 but you can near enough double the speed of a new Vista PC with basic optimising.

Named brand PCs will be heavily loaded with utilities, free software etc. All those fight for resources - especially at startup.

Vista has to be the most insecure O/S ever. I don't mean as in security but in the way it looks after itself. Vista has OCD.

Vista tries to confirm, re-affirm and log EVERYTHING it does It even logs when it is logging. No joke.

If you turn off most of the logs, unecessary services, tune the memory you could see a doubling in speed.

Disks
Consider SSD. These are much cheaper and more reliable now and will really make a difference.

Note that there are some older generation SSD out there so make sure you have the latest (read / write speeds of around 200MB/s, the older types are around 90 to 150 MB/s)

Get a normal hard disk just for backups.

Memory
As already stated you will be limited here by the O/S. If 32 bit and XP or Vista you won't get more than around 3.5Gb to work.

Go for a motherboard with the latest DDR3 memory. This will be the fastest / give best bandwidth.

Graphics
You can get PCs with onboard graphics but this is not ideal as unless it has it's own dedicated memory it will take RAM. Best option is to purchase separately a cheap PCI Express card for around $40.

TravelSite

10+ Year Member



 
Msg#: 3941274 posted 3:01 pm on Aug 19, 2009 (gmt 0)

I take it the Home Premium version of Windows 7 would be fine?

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Hardware and OS Related Technologies / Webmaster Hardware
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved