c# - How to improve selection descendant speed in sitecore? -

-

i need select children (descendants) items filtered template id, under specific item. can in 3 way:

  1. use getdescendants myitem.axes.getdescendants().where(x => x.isoftemplate(myitem.templateid)).select(x => (myitem)x).tolist();

  2. use xpath 

     string q = string.format("{0}//*[@@templateid='{1}']", myitem.paths.path, myitem.templateid);             var result = myitem.database.selectitems(q);

  3. use sitecore search api

i can't use #3 case. let skip case.

xpath selector #2 should work faster #1, problem in first call path.

by reason first call content tree specific path slow. after first call similar calls works fast, doesn't matter witch style use #1 or #2. sitecore add cache.

how improve speed first call ?

though there many ways retrieve items (using link databse mark cassidy has suggested, using siteocre search api etc.) issue cache. if query runs quick enough second time around first time it's part of cache being emptied , refilled. 1 of following: sqldataprovider - prefetch data master|web [data]
master|web [itempaths]
master|web [items]
master|web [paths]

to investigate this, use admin cache page @ /sitecore/admin/cache.aspx , pay particular attention not cache size, delta (change in cache size) caches might affected. if delta has negative values cache being flushed make room newer data. need @ increasing size of cache.

please bear in mind caching should configured particular environment sitecore instance running in, , e.g. recycling application pool flush cache. if it's essential query runs right start, consider adding specific items prefetch cache. adding items prefetch cache on application startup has cost in startup time.

please remember cache configuration should last resort when looking @ slow running code - merely treats symptoms , not root cause.


Comments

Post a Comment

Popular posts from this blog

Spring Boot + JPA + Hibernate: Unable to locate persister -

-
i trying work entity inside request method of spring boot application. entity in project , pom.xml has dependencies it. why error message?: org.hibernate.unknownentitytypeexception: unable locate persister: com.ric.bill.model.bs.par package com.ric.web; import java.util.concurrent.atomic.atomiclong; import javax.persistence.entitymanager; import javax.persistence.persistencecontext; import net.sf.ehcache.cachemanager; import net.sf.ehcache.management.cache; import net.sf.ehcache.management.cachestatistics; import org.hibernate.stat.statistics; import org.springframework.beans.factory.annotation.autowired; import org.springframework.boot.autoconfigure.domain.entityscan; import org.springframework.cache.annotation.enablecaching; import org.springframework.transaction.annotation.enabletransactionmanagement; import org.springframework.transaction.annotation.propagation; import org.springframework.transaction.annotation.transactional; import org.springframework.web.bind.annotati
Read more

go - Golang: panic: runtime error: invalid memory address or nil pointer dereference using bufio.Scanner -

-
i implementing go program uses bufio.scanner , bufio.writer have packaged code follows package main import ( "fmt" "player/command" "strings" ) func main() { //enter code here. read input stdin. print output stdout commands.scanner.scan() { //scan new line , send comand variable check command exist or not input := strings.split(strings.trim(commands.scanner.text(), " "), " ") command := input[0] if command == "" { fmt.printf("$ %s:", commands.pwd) continue } if !commands.commands[command] { commands.throwerror("cannot recognize input.") } else { commands.execute(command, input[1:], nil) } fmt.printf("$ %s:", commands.pwd) } } i using init.go file in main package follows package main import ( "flag" "player/sourc
Read more

c - double free or corruption (fasttop) -

-
this code reads null terminated string file (file containing null terminated strings & should provide index wanted string). error: *** error in `./main': double free or corruption (fasttop): 0x090a4a80 *** aborted code: char *tmp_realloc=null; char *sstring=null; int i=1; /*set file pointer point string*/ fseek(fh,index,seek_set); sstring=(char*)malloc(sizeof(char)); if(sstring == null) return null; tmp_realloc=sstring; while( (*(sstring+i-1)=(char)fgetc((file*)fh)) != 0x0 ) { /*reallocate more memory*/ tmp_realloc=(char*)realloc((char*)sstring,++i); /*if not same address copy old new & set old point new*/ if(tmp_realloc != sstring){ strcpy((char*)tmp_realloc,(char*)sstring); free(sstring); sstring=tmp_realloc; } } could tell me pointer causing issue (& reason) ? remove part /*if not same address copy old new & set old point new*/ if(tmp_realloc != sstring){ strc
Read more