AnsweredAssumed Answered

Search Web-script ftq, where is tunning point?

Question asked by red98hw on Nov 18, 2013
<strong>09:52:37,706</strong> DEBUG [org.alfresco.repo.search.impl.solr.DbOrIndexSwitchingQueryLanguage] Using SOLR query: db-afts for SearchParameters [language=fts-alfresco, query=((학생  AND (+TYPE:"cm:content" +TYPE:"cm:folder")) AND -TYPE:"cm:thumbnail" AND -TYPE:"cm:failedThumbnail" AND -TYPE:"cm:rating") AND NOT ASPECT:"sys:hidden", stores=[workspace://SpacesStore], queryParameterDefinitions=[], excludeDataInTheCurrentTransaction=false, sortDefinitions=[], locales=[], mlAnalaysisMode=null, limitBy=FINAL_SIZE, permissionEvaluation=EAGER, limit=500, allAttributes=[], textAttributes=[], maxItems=-1, skipCount=0, defaultFTSOperator=OR, defaultFTSFieldOperator=OR, queryTemplates={keywords=%(cm:title custom:keyword)}, namespace=http://www.alfresco.org/model/content/1.0, maxPermissionChecks=-1, maxPermissionCheckTimeMillis=-1, defaultFieldName=keywords, fieldFacets=[], useInMemorySort=null, maxRawResultSetSizeForInMemorySort=null, excludeTenantFilter=false, queryConsistency=DEFAULT]

<strong>09:52:43,622</strong> DEBUG [org.alfresco.repo.search.impl.solr.SolrQueryHTTPClient] Sent :/solr/alfresco/afts?
wt=json&fl=DBID%2Cscore&rows=500&df=keywords&start=0&locale=ko_KR&alternativeDic=DEFAULT_DICTIONARY&fq=%7B%21afts%7DAUTHORITY_FILTER_FROM_JSON&fq=%7B%21afts%7DTENANT_FILTER_FROM_JSON

09:52:43,624 DEBUG [org.alfresco.repo.search.impl.solr.SolrQueryHTTPClient]    with: {"queryConsistency":"DEFAULT","textAttributes":[],"allAttributes":[],"templates":[{"template":"%(cm:title custom:keyword)","name":"keywords"}],"authorities":
["GROUP_EVERYONE","ROLE_ADMINISTRATOR","ROLE_AUTHENTICATED","admin"],"tenants":[""],"query":"((학생  AND (+TYPE:\"cm:content\" +TYPE:\"cm:folder\")) AND -TYPE:\"cm:thumbnail\" AND -TYPE:\"cm:failedThumbnail\" AND -TYPE:\"cm:rating\") AND NOT ASPECT:\"sys:hidden\"","locales":["ko_KR"],"defaultNamespace":"http://www.alfresco.org/model/content/1.0','defaultFTSFieldOperator':'OR','defaultFTSOperator':'OR"}
09:52:43,624 DEBUG [org.alfresco.repo.search.impl.solr.SolrQueryHTTPClient] Got: 14556 in 728 ms

<strong>org.alfresco.repo.search.impl.solr.DbOrIndexSwitchingQueryLanguage -> org.alfresco.repo.search.impl.solr.SolrQueryHTTPClient</strong>




Unfoutunately, i'm not well English, Sorry T_T

<strong>52:37.706 ~ 52.43:622 ( 6 second )</strong>… is very long time,

i'm wonder what a happen during 6 second.

how to tunning my code? ( my code is only modifiy slingshot/search.lib.js).








my query config : %(cm:title custom:keyword)

added content document : 800,000

solr info

NUMDOCS           3338380
MAXDOC           3338380
NUMTERMS   29900408
VERSION           1384520570239
OPTIMIZED   FALSE
CURRENT   TRUE
HASDELETIONS   FALSE


my custom property is number of  7~8

, only index set true (custom:keyword).

Outcomes