Article - CS371644
Slow QTime in Solr when using "Search Vendor(Supplier)" transaction in FlexPLM 12.0.0.1
Modified: 22-Jun-2022
Applies To
- FlexPLM 12.0.0.1 to 12.1.2.0
Description
Analysis of Export of Performance Tables set to 1 sample/sec does show Cost in:
wt.index.service.SolrServiceImpl.query(SolrServiceImpl.java:101) wt.indexsearch.FlexSearchDelegate.executeQuery(FlexSearchDelegate.java:158)solr.log is showing high QTime (in msec, see last number in row):
<timestamp of test> INFO (qtp1334042472-24) [ x:wblib] o.a.s.c.S.Request [wblib] webapp=/solr path=/select params={q=%2B((name:(plm\_pt\_testsupplier)))+(+name:(PLM\_PT\_TestSupplier)^20+number:(PLM\_PT\_TestSupplier)^20+creator:(OR\:wt.org.WTUser\:<UserID>)^2+modifier:(OR\:wt.org.WTUser\:<UserID>)^2+)&spellcheck.q=PLM_PT_TestSupplier&start=0&fq=businessType:(com.lcs.wc.supplier.LCSSupplier)&fq=flextyperef_flex:(VR\:com.ptc.core.meta.type.mgmt.server.impl.WTTypeDefinition\:83883+OR+VR\:com.ptc.core.meta.type.mgmt.server.impl.WTTypeDefinition\:223675+OR+VR\:com.ptc.core.meta.type.mgmt.server.impl.WTTypeDefinition\:106612+OR+VR\:com.ptc.core.meta.type.mgmt.server.impl.WTTypeDefinition\:106644+OR+VR\:com.ptc.core.meta.type.mgmt.server.impl.WTTypeDefinition\:223110)&rows=5000&wt=javabin&version=2}
hits=7104 status=0 QTime=13469
This is a printer-friendly version of Article 371644 and may be out of date. For the latest version click CS371644