The performance of DTP API when resource groups are used depends on the file patterns in the resource groups. Performance is most heavily influenced by how the database engine matches the pattern of the string specified. More complex file patterns are slower because they require more complex algorithms for matching strings. From fastest to slowest, the three string matching algorithms: String equality ("=" in SQL) SQL LIKE operator Regular expressions
We have observed that string equality and LIKE can be up to ten times faster than regular expressions. Example File PatternsPattern | Description | Examples |
|---|
String equality (= operator in SQL) | Fastest This pattern contains no wildcards (**, *, or ?). | com.parasoft.foo/src/main/com/parasoft/foo/Alpha1.java Bar.java | SQL LIKE | Fast This pattern ends with a /** or /. | com.parasoft.foo/** com.parasoft.foo/ | SQL regular expressions | Slowest This pattern uses any other use of wildcards. | com.parasoft.foo/*/.java com.parasoft.foo/**/Alpha1.java com.parasoft.foo/src/main/com/parasoft/foo/*.java com.parasoft.foo/src/*/com/parasoft/foo/Alpha1.java com.parasoft.foo/src/main/com/parasoft/foo/Alpha?.java */.java |
|