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
Visit Support Forum Learn More Download Buy It

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