-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 10/31/06 13:48, Merlin Moncure wrote: > On 10/31/06, Adam <adam@xxxxxxxxxxxxxxxxxx> wrote: >> >> >> I recently saw a Hard Disk Drive that is really 4GB of RAM with and SATA >> 1.5Gb/s serial interface. It's basically a hard disk drive that uses >> RAM. >> It also has a battery backup, so if you loose power, you don't loose your >> data. >> >> Has anyone tried using this, and if so was there a noticeable performance >> increase? > > you are talking about the gigabyte i-ram. in the database world, you > can achieve same thing (actually better) by sticking those ram sticks > directly on the motherboard assuming you are in a 64 bit environment > and the motherboard is decent. > > the main advantage of the iram that i see is faster boot times (big > woop). call me when they have a version that does 256gb :-) OLTP rates are *much* higher with SSDs. (Even with lots of system RAM, you *still* have to write the data back to the disk, and that takes time.) But that's only if you've got a small db that needs *really* high tps rates. I'd rather spend my money on enough system RAM to keep the active portion of my DB in the OS cache. - -- Ron Johnson, Jr. Jefferson LA USA Is "common sense" really valid? For example, it is "common sense" to white-power racists that whites are superior to blacks, and that those with brown skins are mud people. However, that "common sense" is obviously wrong. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) iD8DBQFFR7NCS9HxQb37XmcRArbfAJ4kLD4488yY/w/iCr66gamukWtO0wCgob05 1DvyBrP4zI2Un8oO9FEaOc0= =oOuz -----END PGP SIGNATURE-----