Occasionally, we have the opportunity to give the database engine a helping hand, and improve the performance of a long-running SQL query. We do this, by not performing the whole query in SQL. We know better than to perform ORDER BY in SQL (see ‘Embedded SQL.doc’);...
Category: Servers
Learn about the line of cutting-edge server solutions from iXsystems, tailored to meet the demands of your business.
TeraFiler Preview
In anticipation of our anti-vibration rack test, we thought we’d give you a sneak peek of the system we’ll be using to measure the results. Say hello to the TeraFiler. The system features a dual node head with 16 drives in a 3U chassis and 8 external SAS controller...
Green Platform Anti-Vibration Test
A popular video making the rounds in the storage industry is a demonstration of the effects of vibration on the performance of spinning disks. We at iXsystems decided that this new discovery merits more investigation so we decided to run our own tests. The rack we're...
MEGACORE: FreeBSD Foundation and iXsystems collaborate to further the cause of FreeBSD Development
NOTE: This is historical content that may contain outdated information. Never seen anything like this before? This is what one terabyte of RAM and 80 logical CPU cores looks like! For the curious, here are the specs of this monster: Quad Socket System with Dual 10GbE...