Websphere Commerce + SolR:触发的相同 SolR 查询的突发 - 如何调试它



Out商店基于FEP4和Madisons。

当我们重新加载商店首页时,我们看到如下所示的相同 SolR 调用的突发。

编辑:请注意,这是对完全相同产品的查找。因此,如果我们有 2 个产品,我们会看到 2 * 12 = 24 次查找,两组 12 个相同的调用紧接着出现。

我们如何找出导致这些被解雇的原因?是的,结果可能会被缓存,但这是针对每个产品的,在一个繁重的页面上,xmit/get/解包/存储工作加起来有几秒钟......

[10/23/13 18:27:26:933 CEST] 00000160 SystemOut     O WARN  [threadName='WebContainer : 0'] UserDataHelper.getXMBRCLUBRELAccessBean - No XMbrClubRel entry was found for userId -1002 in club 001
[10/23/13 18:27:27:217 CEST] 00000162 SolrCore      I org.apache.solr.core.SolrCore execute [MC_10001_CatalogEntry_da_DK] webapp=/solr path=/select params={q=catentry_id:250059&start=0&timeAllowed=5000&wt=javabin&version=1&fq=storeent_id:("10151"+"10051")&fq=published:1&fq=(+%2B((((+%2BparentCatgroup_id_search:10001_10001+%2Bads_f17_ntk_cs:"1")+(+%2BparentCatgroup_id_search:10001_24451+%2Bads_f17_ntk_cs:"1")+(+%2BparentCatgroup_id_search:10001_32968+%2Bads_f17_ntk_cs:"1")+parentCatgroup_id_search:10001_32972+(+%2BparentCatgroup_id_search:10001_32973+%2Bads_f17_ntk_cs:"1"))+productset_id:("10004")+)+productset_id:("10003")+)+%2B*:*)&debugQuery=false&fl=catentry_id,price_DKK,storeent_id&rows=50} hits=1 status=0 QTime=7 
[10/23/13 18:27:27:282 CEST] 00000162 SolrCore      I org.apache.solr.core.SolrCore execute [MC_10001_CatalogEntry_da_DK] webapp=/solr path=/select params={q=catentry_id:250059&start=0&timeAllowed=5000&wt=javabin&version=1&fq=storeent_id:("10151"+"10051")&fq=published:1&fq=(+%2B((((+%2BparentCatgroup_id_search:10001_10001+%2Bads_f17_ntk_cs:"1")+(+%2BparentCatgroup_id_search:10001_24451+%2Bads_f17_ntk_cs:"1")+(+%2BparentCatgroup_id_search:10001_32968+%2Bads_f17_ntk_cs:"1")+parentCatgroup_id_search:10001_32972+(+%2BparentCatgroup_id_search:10001_32973+%2Bads_f17_ntk_cs:"1"))+productset_id:("10004")+)+productset_id:("10003")+)+%2B*:*)&debugQuery=false&fl=catentry_id,price_DKK,storeent_id&rows=50} hits=1 status=0 QTime=7 
[10/23/13 18:27:27:353 CEST] 00000162 SolrCore      I org.apache.solr.core.SolrCore execute [MC_10001_CatalogEntry_da_DK] webapp=/solr path=/select params={q=catentry_id:250059&start=0&timeAllowed=5000&wt=javabin&version=1&fq=storeent_id:("10151"+"10051")&fq=published:1&fq=(+%2B((((+%2BparentCatgroup_id_search:10001_10001+%2Bads_f17_ntk_cs:"1")+(+%2BparentCatgroup_id_search:10001_24451+%2Bads_f17_ntk_cs:"1")+(+%2BparentCatgroup_id_search:10001_32968+%2Bads_f17_ntk_cs:"1")+parentCatgroup_id_search:10001_32972+(+%2BparentCatgroup_id_search:10001_32973+%2Bads_f17_ntk_cs:"1"))+productset_id:("10004")+)+productset_id:("10003")+)+%2B*:*)&debugQuery=false&fl=catentry_id,price_DKK,storeent_id&rows=50} hits=1 status=0 QTime=7 
[10/23/13 18:27:27:445 CEST] 00000162 SolrCore      I org.apache.solr.core.SolrCore execute [MC_10001_CatalogEntry_da_DK] webapp=/solr path=/select params={q=catentry_id:246411&start=0&timeAllowed=5000&wt=javabin&version=1&fq=storeent_id:("10151"+"10051")&fq=published:1&fq=(+%2B((((+%2BparentCatgroup_id_search:10001_10001+%2Bads_f17_ntk_cs:"1")+(+%2BparentCatgroup_id_search:10001_24451+%2Bads_f17_ntk_cs:"1")+(+%2BparentCatgroup_id_search:10001_32968+%2Bads_f17_ntk_cs:"1")+parentCatgroup_id_search:10001_32972+(+%2BparentCatgroup_id_search:10001_32973+%2Bads_f17_ntk_cs:"1"))+productset_id:("10004")+)+productset_id:("10003")+)+%2B*:*)&debugQuery=false&fl=catentry_id,price_DKK,storeent_id&rows=50} hits=1 status=0 QTime=6 
[10/23/13 18:27:27:526 CEST] 00000162 SolrCore      I org.apache.solr.core.SolrCore execute [MC_10001_CatalogEntry_da_DK] webapp=/solr path=/select params={q=catentry_id:246411&start=0&timeAllowed=5000&wt=javabin&version=1&fq=storeent_id:("10151"+"10051")&fq=published:1&fq=(+%2B((((+%2BparentCatgroup_id_search:10001_10001+%2Bads_f17_ntk_cs:"1")+(+%2BparentCatgroup_id_search:10001_24451+%2Bads_f17_ntk_cs:"1")+(+%2BparentCatgroup_id_search:10001_32968+%2Bads_f17_ntk_cs:"1")+parentCatgroup_id_search:10001_32972+(+%2BparentCatgroup_id_search:10001_32973+%2Bads_f17_ntk_cs:"1"))+productset_id:("10004")+)+productset_id:("10003")+)+%2B*:*)&debugQuery=false&fl=catentry_id,price_DKK,storeent_id&rows=50} hits=1 status=0 QTime=6 
[10/23/13 18:27:27:594 CEST] 00000162 SolrCore      I org.apache.solr.core.SolrCore execute [MC_10001_CatalogEntry_da_DK] webapp=/solr path=/select params={q=catentry_id:246411&start=0&timeAllowed=5000&wt=javabin&version=1&fq=storeent_id:("10151"+"10051")&fq=published:1&fq=(+%2B((((+%2BparentCatgroup_id_search:10001_10001+%2Bads_f17_ntk_cs:"1")+(+%2BparentCatgroup_id_search:10001_24451+%2Bads_f17_ntk_cs:"1")+(+%2BparentCatgroup_id_search:10001_32968+%2Bads_f17_ntk_cs:"1")+parentCatgroup_id_search:10001_32972+(+%2BparentCatgroup_id_search:10001_32973+%2Bads_f17_ntk_cs:"1"))+productset_id:("10004")+)+productset_id:("10003")+)+%2B*:*)&debugQuery=false&fl=catentry_id,price_DKK,storeent_id&rows=50} hits=1 status=0 QTime=7 
[10/23/13 18:27:27:681 CEST] 00000162 SolrCore      I org.apache.solr.core.SolrCore execute [MC_10001_CatalogEntry_da_DK] webapp=/solr path=/select params={q=catentry_id:243989&start=0&timeAllowed=5000&wt=javabin&version=1&fq=storeent_id:("10151"+"10051")&fq=published:1&fq=(+%2B((((+%2BparentCatgroup_id_search:10001_10001+%2Bads_f17_ntk_cs:"1")+(+%2BparentCatgroup_id_search:10001_24451+%2Bads_f17_ntk_cs:"1")+(+%2BparentCatgroup_id_search:10001_32968+%2Bads_f17_ntk_cs:"1")+parentCatgroup_id_search:10001_32972+(+%2BparentCatgroup_id_search:10001_32973+%2Bads_f17_ntk_cs:"1"))+productset_id:("10004")+)+productset_id:("10003")+)+%2B*:*)&debugQuery=false&fl=catentry_id,price_DKK,storeent_id&rows=50} hits=1 status=0 QTime=5 
[10/23/13 18:27:27:748 CEST] 00000162 SolrCore      I org.apache.solr.core.SolrCore execute [MC_10001_CatalogEntry_da_DK] webapp=/solr path=/select params={q=catentry_id:243989&start=0&timeAllowed=5000&wt=javabin&version=1&fq=storeent_id:("10151"+"10051")&fq=published:1&fq=(+%2B((((+%2BparentCatgroup_id_search:10001_10001+%2Bads_f17_ntk_cs:"1")+(+%2BparentCatgroup_id_search:10001_24451+%2Bads_f17_ntk_cs:"1")+(+%2BparentCatgroup_id_search:10001_32968+%2Bads_f17_ntk_cs:"1")+parentCatgroup_id_search:10001_32972+(+%2BparentCatgroup_id_search:10001_32973+%2Bads_f17_ntk_cs:"1"))+productset_id:("10004")+)+productset_id:("10003")+)+%2B*:*)&debugQuery=false&fl=catentry_id,price_DKK,storeent_id&rows=50} hits=1 status=0 QTime=7 
[10/23/13 18:27:27:818 CEST] 00000162 SolrCore      I org.apache.solr.core.SolrCore execute [MC_10001_CatalogEntry_da_DK] webapp=/solr path=/select params={q=catentry_id:243989&start=0&timeAllowed=5000&wt=javabin&version=1&fq=storeent_id:("10151"+"10051")&fq=published:1&fq=(+%2B((((+%2BparentCatgroup_id_search:10001_10001+%2Bads_f17_ntk_cs:"1")+(+%2BparentCatgroup_id_search:10001_24451+%2Bads_f17_ntk_cs:"1")+(+%2BparentCatgroup_id_search:10001_32968+%2Bads_f17_ntk_cs:"1")+parentCatgroup_id_search:10001_32972+(+%2BparentCatgroup_id_search:10001_32973+%2Bads_f17_ntk_cs:"1"))+productset_id:("10004")+)+productset_id:("10003")+)+%2B*:*)&debugQuery=false&fl=catentry_id,price_DKK,storeent_id&rows=50} hits=1 status=0 QTime=8 
[10/23/13 18:27:27:902 CEST] 00000162 SolrCore      I org.apache.solr.core.SolrCore execute [MC_10001_CatalogEntry_da_DK] webapp=/solr path=/select params={q=catentry_id:250059&start=0&timeAllowed=5000&wt=javabin&version=1&fq=storeent_id:("10151"+"10051")&fq=published:1&fq=(+%2B((((+%2BparentCatgroup_id_search:10001_10001+%2Bads_f17_ntk_cs:"1")+(+%2BparentCatgroup_id_search:10001_24451+%2Bads_f17_ntk_cs:"1")+(+%2BparentCatgroup_id_search:10001_32968+%2Bads_f17_ntk_cs:"1")+parentCatgroup_id_search:10001_32972+(+%2BparentCatgroup_id_search:10001_32973+%2Bads_f17_ntk_cs:"1"))+productset_id:("10004")+)+productset_id:("10003")+)+%2B*:*)&debugQuery=false&fl=catentry_id,price_DKK,storeent_id&rows=50} hits=1 status=0 QTime=8 
[10/23/13 18:27:27:965 CEST] 00000162 SolrCore      I org.apache.solr.core.SolrCore execute [MC_10001_CatalogEntry_da_DK] webapp=/solr path=/select params={q=catentry_id:246411&start=0&timeAllowed=5000&wt=javabin&version=1&fq=storeent_id:("10151"+"10051")&fq=published:1&fq=(+%2B((((+%2BparentCatgroup_id_search:10001_10001+%2Bads_f17_ntk_cs:"1")+(+%2BparentCatgroup_id_search:10001_24451+%2Bads_f17_ntk_cs:"1")+(+%2BparentCatgroup_id_search:10001_32968+%2Bads_f17_ntk_cs:"1")+parentCatgroup_id_search:10001_32972+(+%2BparentCatgroup_id_search:10001_32973+%2Bads_f17_ntk_cs:"1"))+productset_id:("10004")+)+productset_id:("10003")+)+%2B*:*)&debugQuery=false&fl=catentry_id,price_DKK,storeent_id&rows=50} hits=1 status=0 QTime=6 
[10/23/13 18:27:28:033 CEST] 00000162 SolrCore      I org.apache.solr.core.SolrCore execute [MC_10001_CatalogEntry_da_DK] webapp=/solr path=/select params={q=catentry_id:243989&start=0&timeAllowed=5000&wt=javabin&version=1&fq=storeent_id:("10151"+"10051")&fq=published:1&fq=(+%2B((((+%2BparentCatgroup_id_search:10001_10001+%2Bads_f17_ntk_cs:"1")+(+%2BparentCatgroup_id_search:10001_24451+%2Bads_f17_ntk_cs:"1")+(+%2BparentCatgroup_id_search:10001_32968+%2Bads_f17_ntk_cs:"1")+parentCatgroup_id_search:10001_32972+(+%2BparentCatgroup_id_search:10001_32973+%2Bads_f17_ntk_cs:"1"))+productset_id:("10004")+)+productset_id:("10003")+)+%2B*:*)&debugQuery=false&fl=catentry_id,price_DKK,storeent_id&rows=50} hits=1 status=0 QTime=7 

看起来这是某个类别或搜索页面的一个。 对于每个产品/项目面板,您正在运行一个 solr 调用(来自内部触发的 jsp 的目录导航视图 BOD 调用)以获取详细信息。

您可以通过在单个 BOD 调用中获取所有数据,通过将多个唯一 ID 传递给单个 BOD 调用来更改代码流的方式。

此外,我觉得 SOLR 调用本质上非常轻,因此这些调用数量没有太大的性能缺陷。

Websphere 商务性能的一个非常简单快捷的胜利是数据对象缓存上的图灵,我真的不知道为什么他们不将其设置为默认值。

http://pic.dhe.ibm.com/infocenter/wchelp/v7r0m0/topic/com.ibm.commerce.admin.doc/tasks/tdcenabcommdatacache.htm

最新更新