Re: expanding ram



In article <504d2046-4572-42dc-be09-895e2b630c37@xxxxxxxxxxxxxxxxxxxxxxxxxxx>,
carlbernardi@xxxxxxxxx <carlbernardi@xxxxxxxxx> wrote:
Hi, I have question about expanding ram.

Presently, I am working with some very large databases( in the 500
gig range) and I am searching for an inexpensive way to have the
entire databases in memory. Given that my knowledge of hardware is not
that in depth I was wondering if someone knew the best way to expand
memory to avoid using hardrives which are much slower than ram.
I am considering:
USB
FIREWIRE
BLUETOOTH
and any other possibilities.

Since cheap mother boards can only hold up to a few gigs unless
you can afford a super computer, I was thinking about having my
databases put on USB flash drives attached through a USB hub * 2
(because must computers have 2 usb ports) adding for example 16gig usb
drive * 2 hubs * 4 ports per hub is 128 gigs. I don't think there is
any common mother board out there that can hold that kind of ram.

USB flashsticks are substantially slower than hard drives connected over
IDE/SATA/SCSI/etc. You'd also need a few dozen of them hanging off of one
computer to get the storage you need. For that matter, hard drives
connected over USB or FireWire are going to be slower than hard drives
connected over IDE/SATA/SCSI/etc. Bluetooth isn't even a contender, as its
top speed of about 700 kbps is a couple orders of magnitude slower.

Your only feasible option, as I see it, is to put the database on a RAID
array made with the fastest drives you can get. RAID-5 on some 15-krpm
SCSI or SAS drives would most likely be the fastest you can get with current
technology. RAID-5 on 10-krpm SCSI, SAS, or SATA drives would save some
money with (hopefully) not too big a speed hit.

_/_
/ v \ Scott Alfter (remove the obvious to send mail)
(IIGS( http://alfter.us/ Top-posting!
\_^_/ rm -rf /bin/laden >What's the most annoying thing on Usenet?

.



Relevant Pages

  • Re: How can I measure correct polarity
    ... It does it's job but drives aren't something I get attached to. ... USB is a lot slower than internal SATA II :-) ... pulls the voltage down too much. ...
    (sci.electronics.repair)
  • Re: Scanner recommendation
    ... make Firewire actually faster than USB: ... FAR slower. ... since few drives on the market can burst above FW800, ...
    (comp.periphs.scanners)
  • Re: Really slow USB2 pen transfer speed when copying many small files?
    ... > has anyone every tried copying many small files onto a large USB 2.0 ... I bought a USB 2.0 PNY 256M drive at Fry's ... drives online and they are terribly slow, ... I'm not sure why 'cp' and 'cmdsync' are so much slower. ...
    (microsoft.public.windows.file_system)
  • speed of USB HD?
    ... its not much slower in the case of a 3.5 inch drive on ... the speed isnt really limited by the buswidth which is ... >In real life what is the experience of the speed of USB ... >drives compared to an internal IDE ATA100 drive? ...
    (microsoft.public.windowsxp.hardware)
  • Re: Any public postgresql/mysql server on Internet?
    ... I have two of your apps in Puppy -- countdown and regexpviewer! ... Puppy is supplied as a live-CD, and there are simple scripts to install to usb, ... USB Flash drives are one of main reasons people are interested in Puppy. ... -- Puppy currently has Gequel, which is a client for mySql databases, don't ...
    (comp.lang.tcl)

Loading