In the latest versions of Advanced ETL Processor and Visual Importer ETL  processing Date filelds works up to 10 percent faster.

Old Version

date performace 1

New Version

date performace 1

Performance tips for processing Date Fields:

  • Formats with single character are the slowest, for example YYYY-M-D  has sigle M and D
  • Three characters are slow as well, for example YYYY-MMM-DD
  • Use relevant format for example if the data looks like this 2001-02-01 format YYYY-MM-DD HH:NN:SS.FFF will work but YYYY-MM-DD will be faster
  • Special tip for Advanced ETL Processor if the data is already in YYYY-MM-DD HH:NN:SS.FFF format there is no need to convert it
Visit Support Forum Learn More Download Buy It

We have 429 guests and 3 members online