Welcome to WebmasterWorld Guest from 188.8.131.52
Forum Moderators: open
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?
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.
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
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.
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.
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.
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.