BLOG. SMART PRACTICAL BUSINESS ADVICE

Welcome to the SSD club, Amazon EC2 (and how SSD’s powered a 714% Performance Increase

Big capital investment into Solid State Drives to power it's SaaS Business Management platform has proven a smart choice by WORK[etc] as performance increases over 100x for database read and writes.

Back in February we announced our massive infrastructure upgrade and how we were taking a risk moving all our database storage onto a SSD (Solid State Drives) storage platform.  Now Amazon has just announced SSD-powered instances of its cloud-computing platform, EC2.

For those that don’t know SSD (Solid State Drives) are flash based memory that can massively improve the performance of computers.  Unlike normal hard-drives, an SSD has no spinning platter and no moving parts.

If you’ve bought a new laptop lately, with a SSD drive, then you’ve already experienced the profound impact they have; boot times are reduced and applications seem to launch instantly.

In terms of actual numbers, an enterprise level SSD drive can shuffle data around at speeds of ~500MB/s, whereas your traditional hard drive is going to max out at 140MB/s.  The critical figure for database heavy applications like WORK[etc] is the random access time.  This is the time it takes for the hard drive to retrieve and read data.  For a SSD that time is 0.1 ms, for a traditional drive we’re talking around 8 – 12ms – resulting in a 100x improvement.

But all this cost comes at a price.  SSD drives can be ~10 x the cost of normal drives and if you need ultra-reliability and performance for data-centre use, quadruple that figure again.

When we started buying Toshiba enterprise drives late last year, they were ~$2000 per drive.  We now have 16 of the suckers running.  But well worth it as the results have been incredible.

This is how the WORK[etc] infrastructure performed pre-SSD:

  • Avg. Disk Queue Length: 1.5
  • Avg. Disc sec/Read: 0.008
  • Avg. Disc sec/Write: 0.005
  • CPU: 29.5%

What we’re seeing is the average disk queue length of 1.5 (product of Avg. Disk sec/Transfer multiplied by Disk Transfers/sec – so bigger the number, the longer the queue for your database request) and the time to read data sitting in at .008 seconds.

This means that a packet of data (ie a request to display something from your WORK[etc] database) is first sitting in a queue and then taking an amount of time to be read back.

Post SSD the numbers speak for themselves:

  • Avg. Disk Queue Length: 0.21
  • Avg. Disc sec/Read: 0.001
  • Avg. Disc sec/Write: 0.001
  • CPU: 6.8%

The disk queue length is way under a factor of “1” for an improvement of 714%.  And amazingly the average disc sec/read is 0.001 – which may as well be zero seconds.  You’ll notice the CPU utilization is running significantly lower also.

Server-Admins/Network Engineers Note: Obviously this comparison is fluffy as we haven’t weighted results for any number of variables.  The goal here is only to provide a basic overview of the technology involved and performance gains.

Improving Network Speeds

The next big performance upgrade we’re right in the middle of rolling out is a migration to the Akamai content optimized network (Akamai Web Application Accelerator).  What this means is that instead of your WORK[etc] data traveling through the public Internet, it will instead find the closest of Akamai’s 22,000 international data points and then travel across a private and optimized network.

Running over the Akamai network is kinda like pulling out of your driveway in the morning, reaching the end of your street and then turning onto your own teflon-coated private lane all the way to the office.  The longer the distance you have to go, the greater the speed improvement.  And if there is bad weather ahead a new lane magically appears to take you another route.

We’re almost done testing internally and will be rolling out later this month.  I’ll publish some cool charts here showing the speed performance from different origination points around the globe.

New UX Update:

The first batch of beta upgrades to the new UX has just started.  We’re running 1 batch on Monday, and if all goes well, another batch on Wednesday and then the final on Friday.

About the biggest issue we’re seeing right now is that it the interface is a little sluggish on FireFox because of FF’s javascript engine.  On the latest Internet Explorer and Chrome it is super snappy.

I’ve experienced this first hand, having been a FF fan since version 2.0.  But the inconvenience of switching across to IE is worth it for the better experience across not just the new WORK[etc], but also other sites as well.

See all

Featured Posts

Multitasking is Killing Your Productivity. Here’s How to Save It

Just like every other small business owner, I juggle a lot of tasks as the owner and founder of WORKetc. One minute I’m overseeing development on our web app, and the next I’m on a sales call with a potential customer. Sales, support, projects, finance—I’m basically both leader and member of these very different departments […]

4 More Tried and Tested WORKetc Tips from Real Users

Efficiency and productivity aren’t just buzzwords when it comes to running a small business. They could make the difference between you leading the pack and being dead last. This is particularly critical in an economic climate where profit margins are tighter than spandex. The only way to stay afloat is to make sure your entire […]

Top New Apps to Automate, Manage, & Grow Your Small Business in 2018

Ever tried unscrewing a screw using a coin? It can be done, but it takes much more time and effort than if you just use a screwdriver. It’s the same with apps. There’s a glut of them out there, and finding the right ones to automate, manage, and grow your small business can make the […]

Real Users Reveal How They Save Time with WORKetc’s Mobile Apps

Up until around eight or nine years ago, I always kept a small notebook with me wherever I went. I was already knee-deep into my entrepreneurial ventures back then, and that notebook was pretty much my database for everything related to my businesses. Contacts, sales leads, project info, ideas both practical and slightly mad—I kept […]

Top 4 WORKetc App Integrations, As Picked by Real Users

There’s not a lot WORKetc can’t do when it comes to managing a small business, what with its built-in CRM, project management, billing, timesheets, and customer support modules. It’s an entire business management ecosystem unto itself without even plugging in any additional third-party apps. We do recognize, however, that some businesses have their own app […]

How to Win That Elusive “Yes” for Your Sales Quotes and Proposals

If first contact with a sales lead is like a first date, then sending out a sales quote would be the equivalent of getting down on one knee and proposing. Now, putting your best foot forward on that first date is just the start. If you want to get a “yes”, you better be ready […]