One of the things that make relational databases so efficient is that they are optimized to run on a spinning magnetic disk (like a hard drive). They take time to know just where the head is located physically over the platter and move it in the most efficient manner. This isn't to say that they won't run faster on a solid-state memory device, just that you throw out a lot of hard work if you do.

I don't think this is a reason not to move to a solid-state storage device, just something to keep in mind. If you can justify getting a TB memory array for your application, go ahead.

I don't know if there is any real optimization you can do for solid-state devices, or if those optimizations will even make for a significant speed advantage.

"There is no shame in being self-taught, only in not trying to learn in the first place." -- Atrus, Myst: The Book of D'ni.

In reply to Re: [OT] End of hard disks era, new ways of development by hardburn
in thread [OT] End of hard disks era, new ways of development by woolfy

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.