In the latest versions of Advanced ETL Processor and Visual Importer ETL  processing Date fields 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 single M and D
  • Three characters are slow as well, for example, YYYY-MMM-DD
  • Use the 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
Direct link, no registration required.