Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DTPDEVEL and version 5.4.0

...

Excerpt

About Resource Group Performance

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:

  1. String equality ("=" in SQL)

  2. SQL LIKE operator

  3. Regular expressions

We have observed that string equality and LIKE can be up to ten times faster than regular expressions.

Example File Patterns

Scroll Table Layout
widths30%,30%,40%

Pattern

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

...