Hi again,
Thank you very much for your prompt reply.
I admit I am quite new to the whole server configuration/ system
administration and have not myself setup the servers, do you know how I can
check for a proxy in a remote server? The arangoDB setup is Single as far
as I know.
Regarding the query, I have not written that either but seems like this
when choosing the EXPLAIN. I can see that there is surely one index used.
Query string:
LET params = {
data: {
pagePreview: @previewMode,
langCode: @langCode,
fallbackLangCode: @fallbackLangCode,
searchLocalized: @searchLocalized,
pageStatus: @pageStatus,
inSiteMap: @inSiteMap,
activeLanguageMismatch: @activeLanguageMismatch,
pageAttrFilters: @pageAttrFilters,
pageAttrSort: @pageAttrSort,
pageFieldFilters: @pageFieldFilters,
pageFieldSort: @pageFieldSort
}
}FOR v, dOr, p IN @minDepth..@maxDepth OUTBOUND @id pageTree
LET d = CALL("cms3::getPageChildrenVisitor", v, dOr, p, params)FILTER
d != null &&
(d.pageStd_typeKey==@filter0 && (LIKE(d.pageField_model,@filter10, true) ||
LIKE(d.pageField_title,@filter11, true) || LIKE(d.pageField_content,
@filter12, true) ) ) SORT
d.pageStd_depth DESC, d.pageStd_vOrder DESC LIMIT 0, 20 RETURN d
Execution plan:
Id NodeType Est. Comment
1 SingletonNode 1 * ROOT
3 TraversalNode 597 - FOR v /* vertex */, dOr /* edge */, p /*
paths */ IN 1..10 /* min..maxPathDepth */ OUTBOUND 'page/1' /* startnode */
pageTree
4 CalculationNode 597 - LET d = CALL(
"cms3::getPageChildrenVisitor", v, dOr, p, { "data" : { "pagePreview" : 1,
"langCode" : "el", "fallbackLangCode" : "en", "searchLocalized" : 0,
"pageStatus" : 20, "inSiteMap" : 1, "activeLanguageMismatch" : 0,
"pageAttrFilters" : [ ], "pageAttrSort" : [ ], "pageFieldFilters" : [
"model", "title", "content" ], "pageFieldSort" : [ ] } }) /* v8
expression */
5 CalculationNode 597 - LET #7 = ((d != null) &&
((d.`pageStd_typeKey` == "product") && ((LIKE(d.`pageField_model`, "%hea%",
true) || LIKE(d.`pageField_title`, "%hea%", true)) ||
LIKE(d.`pageField_content`, "%hea%", true)))) /* simple expression */
6 FilterNode 597 - FILTER #7
7 CalculationNode 597 - LET #9 = d.`pageStd_depth` /*
attribute expression */
8 CalculationNode 597 - LET #11 = d.`pageStd_vOrder` /*
attribute expression */
9 SortNode 597 - SORT #9 DESC, #11 DESC
10 LimitNode 20 - LIMIT 0, 20
11 ReturnNode 20 - RETURN d
Indexes used:
By Type Collection Unique Sparse Selectivity Fields
Ranges
3 edge pageTree false false 52.77 % [ `_from`, `_to` ]
base OUTBOUND
Traversals on graphs:
Id Depth Vertex collections Edge collections Options
Filter conditions
3 1..10 pageTree uniqueVertices: none,
uniqueEdges: path
Optimization rules applied:
Id RuleName
1 move-calculations-up
2 move-filters-up
3 remove-unnecessary-calculations
4 move-calculations-up-2
5 move-filters-up-2
If you have any further insights on these I would be grateful to hear them.
Best,
Eleni
--
You received this message because you are subscribed to the Google Groups
"ArangoDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
