NOTE! This site uses cookies and similar technologies.

If you not change browser settings, you agree to it. Learn more

I understand

Advanced ETL Processor News

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

Great news Advanced ETL Processor is nearly 2 times faster than Pentaho Kettle

Simple test: Parsing CSV files

ProductRecords per secondTime Taken
Advanced ETL Processor 169295 1min 27sec
Pentaho Kettle 954440 2min 34sec
Pentaho Kettle Transformation 

Pentaho Kettle Text FIle Transformation

Pentaho Kettle Text FIle Transformation Performance

 

Advanced ETL Processor Transformation

  Advanced ETL Processor - Transforming Files

Notes:

  1. Performance also depends on hardsware configuration
  2. We used two different computers for testing, on the first one AETL was 3 times faster than Pentaho Kettle
  3. Please use our support forum to provide us with feedback
Visit Support Forum Learn More Download Buy It
"AETL is a perfect fit for our requirements as it offers process automation and integration in one single package. This initiative has helped us to improve our business process efficiency and timeliness."

Sue K,
Online Logistics

Our customers

BP

BBC

HSBC

Orange

CAT

SEPA
emc
NHS
Australian Rugby Union
xerox
Databases we work with