Sorting algorithms are one of the most studied in computer science.

It is extremely hard to invent something new and yet every year there are new papers published about the subject. There are several well-known sorting algorithms:  Insertion, Selection, Bubble, Shell, Merge, Heap and Quicksort. More information about sorting algorithms:

http://www.sorting-algorithms.com/

At though it is all nice and clear there is just one problem: the compiler does not know anything about sorting.

So all the code generated must be carefully reviewed and optimized.

Our developers have just completed data sorting optimisation and the result is quite positive:

Version 5.8.0.18 is 2 times faster than version 5.8.0.12 and 12 times than version 5.8.0.6

On top of that, it sorts data faster than Pentaho Kettle and it should be possible to make it even faster

Testing results:
VersionRecords per secondTime Taken
5.8.0.18 75,222 39 sec
5.8.0.12 32,832 1 min 31 sec
5.8.0.6 5,451 7 min 45 sec
5.8.0.18 

Sorting Data Faster

5.8.0.12

Sorting Data Version 5.0.8.12

5.8.0.6

Sorting Data Old Version

Sorting data using Pentaho Kettle

Pentaho Kettle Sorting Example

Pentaho Kettle Sorting Results

 

Notes:

  1. The performance also depends on the hardware configuration
  2. A bigger sorting buffer improves performance
  3. Please use our support forum to provide us with feedback
Direct link, no registration required.
 

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies