Advanced ETL Processor News

New version of Advanced ETL Processor

making etl tools better

Old version of Advanced ETL Processor

making etl tools better1

Visit Support Forum Learn More Download Buy It

New version of Advanced ETL Processor is available for download

Chages are:

 + Up to 2 times faster data extraction from Sql Server
 + Up to 2 times faster data extraction from ODBC sources
 + Up to 40 percent faster loading data into SQL Server
 + Up to 40 percent faster loading data into ODBC
 + Up to 10 percent faster QVX files creation
 + Up to 10 percent faster loading data into PostgreSQL
 - Various bugs fixes and improvements

Here are our test results: pooling data from Sql server

VersionRecords per secondTime Taken
5.8.0.19 41,100 1min 12sec
5.8.0.6 21,436 2min 19sec

Extract Data From SQL Server NEW Version

 Extract Data From SQL Server OLD Version

Notes:

  1. Performance also depends on the hardware configuration
  2. Please use our support forum to provide us with feedback
Visit Support Forum Learn More Download Buy It

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 know sorting algorithms:  Insertion, Selection, Bubble, Shell, Merge, Heap and Quick sort. More information about sorting algorithms:

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

At though at 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. Performance also depends on the hardware configuration
  2. Bigger sorting buffer improves performance
  3. Please use our support forum to provide us with feedback
Visit Support Forum Learn More Download Buy It

We are here to help and we mean it

 brain target boy   letter

Step-by-Step tutorials

Sharpen your skills by watching online tutorials and guides

Online Documentation

Read detailed online Wiki Documentation

Support Forum

Ask questions share ideas and discuss sulutions online

Contact Us

Use online contact form to ask questions

Could not find what you were looking for?   Just ask