100x speed difference between indexof() and matches()

twelveeighty

• February 18, 2011 00:00

• Answered

Follow

Being used by now to the usually blazing speed of CloverETL, I was stunned to see one of my graphs crawling at a pace of 10 records/second instead of the usual 1,000/s or better.

Upon investigation, I narrowed it down to one line of code in my Reformat block:

string myString = $0.SOMEFIELD;

if ((indexOf(myString, 'STREET')>=0))

When I replaced this with:

if (matches(myString, '.*STREET.*')

My graph runs 100 times faster!!

Is this a known issue?

• 

  avackova

  • February 21, 2011 10:23

  0

  Comment actions Permalink

  Hello,
  we know about the problem (http://bug.cloveretl.org/view.php?id=4778) and we are working on resolving it.

Please sign in to leave a comment.