Xenomorph
  • Solutions
  • Technology
  • Customers
  • Resources
  • News
  • About Us
  • Request a Demo
  • Search
  • Menu Menu
  • Twitter
  • LinkedIn

News

Solid State Drives – the promise of a free lunch?

I read an interesting article a few weeks ago on the SQL Server Magazine web-site where the issue of Solid State Drives (SSD) and their potential to impact the future need to tune databases was being discussed.

The article raised the question that as SSD becomes more mainstream, and its capacity increases significantly, then could it eventually eliminate the need for database designers/administrators to have to optimise table structures to deliver acceptable levels of performance?

The argument used was along the lines that with SSD there’s less traditional disk i/o going on (making reads a thousand times quicker than hard disks), so query performance levels may just be acceptable by virtue of the SSD memory delivering data quickly to the consumer process. This makes good sense, but also reminds me of previous technology advances in this area such as RAM disks and even paging files, which all promised such things but eventually needed cleverer system infrastructure around them to fulfil an overall business need.

That said, I have absolutely no doubt that SSD will make a significant impact on data storage access times (it has to). However, my guess is that it will just push the problem elsewhere. So, as much as we developers & technicians would like to think that it may deliver us a ‘free lunch’, I would suggest it’s more likely to be a ‘free starter’ and that (sadly) we will continue to have much more work to do to produce the main course and dessert that will keep our customers happy and coming back for more… 

Share this entry
  • Share on Twitter
  • Share on LinkedIn
  • Share by Mail
https://www.xenomorph.com/wp-content/uploads/2019/07/logo-xeno.png 0 0 Jean-Paul Carbonnier https://www.xenomorph.com/wp-content/uploads/2019/07/logo-xeno.png Jean-Paul Carbonnier2008-09-24 14:16:242020-02-11 11:13:58Solid State Drives – the promise of a free lunch?

Categories

  • Blog Post
  • Events
  • Press Release

Archives

About Xenomorph

Xenomorph provides trusted data management solutions to many of the world’s leading financial institutions.

With more than two decades’ experience managing large volumes of complex data and analytics we can quickly configure a solution for your requirements.

Xenomorph London

4th Floor
10 Lloyd’s Avenue
London EC3N 3AJ
UK

+44 (0)20 7614 8600

info@xenomorph.com

map

Xenomorph New York

45 Rockefeller Plaza, FL 20
New York
NY 10111
USA

+1-212-401-7894

info@xenomorph.com

map


Xenomorph Boston

53 State Street
Suite 500
Boston, MA 02109
USA

+1-617-465-2050

info@xenomorph.com

map

© Xenomorph Software Ltd 2022 - Privacy policy | Anti-Bribery Policy
Scroll to top
This website uses cookies to improve your experience. If you continue to use the site we will assume your consent. ACCEPTRead More
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are as essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
SAVE & ACCEPT