Article - CS340462

Windchill Rest Services (WRS) API servlet/odata/DocMgmt/Documents$expand=PrimaryContent is slow in Windchill PDMLink 11.1

Modified: 17-Mar-2021   


Applies To

  • Windchill PDMLink 11.1 M020-CPS16
  • Windchill 2.1 REST Services

Description

  • API Servlet/odata/DocMgmt/Documents$expand=LatestSearch($expand=PrimaryContent;$select=ID,VersionID,Name,Number,State,Version), $filter=(startswith(Name,'s') and contains(Name,'p')) or (startswith(Number,'s') and contains(Number,'p')) has performance issue
    • Performance is good without $expand=PrimaryContent
    • Needs more than 2 minutes to get 500 results
    • No slow SQLs, and most of time consumed by CPU
This is a printer-friendly version of Article 340462 and may be out of date. For the latest version click CS340462