The document discusses how to improve Windows computer performance by using Intel ® Optane ™ storage technology as an upgrade over normal hard disk drives. In particular,use as a device for the SuperFetch and ReadyBoost functions; use as the drive holding Windows itself as well as other heavily used applications; and use as a server drive holding a reasonably large and active database. The document discusses database table key structures in the context of our SAITO application software needing to insert 100,000 rows of sensor data per minute. Click the link below to download a 3 megabyte 32 page PDF
We give three scenarios: inserts of table rows with natural keys (two integers plus a datetime); inserts of table rows with GUIDs as the keys; and archiving which can be thought of as a SQL SELECT of many rows, writing the data to a text file, deleting the rows, and then inserting corresponding rows in a table stored on a disk. We show results using a Microsoft SQL Server 2014 database.
Timings are in seconds (3600 = 1 hour) for approximately 16 million rows.
|Insert natural keys||1 thread||16 threads||32 threads|
|Insert GUID keys||1 thread||16 threads||32 threads|
|Archive||1 thread||16 threads||32 threads|
We would summarize as follows: the Optane was roughly FOUR to SIX times faster than a very good hard disk and ALMOST THREE times faster than a modern solid state drive.
Everyone should obtain an Optane.
We note that GUIDs should not be a designer’s first choice for a key and that 32 threads are very likely to be an over-subscription for many machines, so the measures using 16 threads are probably going to be more commonly encountered in practice.
One time-honored soution is to upgrade the processor. This can get rather complicated if motherboards, memory, fans and power supplies are in play. The Extreme Core I7 (rightmost) has 10 cores (20 threads with HyperThreading) and quad channel DDR4 memory with a huge 25 megabytes of cache. And, as advertised, the new Intel Turbo Boost Max Technology 3.0 does provide more than 10% improvement in single-thread work.
But we really had a input-output problem: the disk was the limiting factor.
There was strident insistence that the Intel Optane (above right) would only work on Windows 10 64-bit systems AND only with with Intel’s seventh (7th) generation Kaby Lake processors. We were told only the H270, Q270, Z270, B250 and Q250 chipsets would work. So we were forced to use an excellent CPU.
“When they begin the beguine …
It brings back a memory evergreen”
“Begin the Beguine” – Cole Porter 1935
Written on the RMS Franconia during a voyage from Indonesia to Fiji as part of an around the world cruise, the song was performed in a musical titled Jubilee. It was re-recorded as an instrumental by Artie Shaw leading his big band in 1938, and soon anyone who was anyone musical had done a version of it. Then and now, the song challenges musicians and vocalists with its length, lyrics and structure, all quite different from most songs.
We foresee FOUR major uses of the Intel ® Optane ™ technology for servers, laptops and desktops using a Microsoft Windows operating system (and likely most other OSes):
- A cache drive used by the built-in SuperFetch and ReadyBoost functions. We obtained six to eight times faster program load times for Windows itself and for some application programs. It is difficult to control what SuperFetch and ReadyBoost do.
- A system drive holding Windows itself and select application executables. Similar results to #1, although a user has more control due to being able to select what is on the drive. In both cases performance speed-ups are a function of how often various programs are loaded, whether the files had previously been on a hard disk or a solid state drive, and how much paging is done.
- Two drives or one partitioned drive with one acting as a system drive holding Windows itself and select application executables AND one drive holding, in our case, a large SQL database. Under intense loads, which included extreme multi-threading, we obtained results varying from four to almost twenty times faster. We discuss the details in depth but this should motivate intense and immediate consideration in finance, logistics (air traffic and flight control), medicine and military sectors, to name a few.
- We imagine hard disk makers will include Optane ™ in hybrid drives