asp.net - How to prevent Orchard projections from firing hundreds of queries -


i have following problem projections module in orchard:
have pages main categories when opened query database (not orchard one, coming separate application) it's subcategories , items in subcategories.

i have projection shows main category titles in widget easy navigation. page load times skyrocket because in projection tries load each main category whole resulting in exponential amount of queries against our second database , loading times in excess of 30 seconds.

is possible projections module query title part (and perhaps custom bindings) , ignore part executes queries?

thanks in advance.

edit

we used mini profiler , result:
mini-profiler output

it seems problem in display method of orchard.projections.drivers.projectionpartdriver on line 111: 

var contentitems = _projectionmanager.getcontentitems(query.id, pager.getstartindex() +     part.record.skip, pager.pagesize).tolist();

what can it?

i think n+1 query issue caused fact parts' records lazily loaded, it's 1 subsequent query each fetched item each accessed part.

with contentquery there queryhints eagerly load part records ihqlquery (the query used in projector filters) use join() method join in (= eagerly load) tables. needs write code: creating projector filter provider joins in tables, use filter respective queries.

i don't know of simpler option eager loading projector it's worth exploring. why don't open issue this?


Comments

Post a Comment

Popular posts from this blog

linux - xterm copying to CLIPBOARD using copy-selection causes automatic updating of CLIPBOARD upon mouse selection -

i've tried various ways coerce xterm (versions 285 , 292) copy selection clipboard clipboard whenever press ctrl-shift-c. promising way far has been, in ~/.xresources, put this: xterm*vt100.translations: #override \ ctrl shift <keypress> c: copy-selection(clipboard) \n\ ctrl shift <keypress> v: insert-selection(clipboard) ctrl-shift-v works perfectly, copying has nuance... if restart xterm, highlighting text puts things in primary clipboard; expected, proper, default behavior. if hit ctrl-shift-c, copies current selection clipboard clipboard. the bug, however, if highlight text after first time pressed ctrl-shift-c, you'll see highlighting copies both primary and clipboard. cannot figure out how stop xterm updating clipboard upon selection... , doesn't make sense me in first place. i said, @ specific point in time, copy selection clipboard... yet starts updating automatically upon selection after doing once... anyone have workaround...
Read more

c++ - qgraphicsview horizontal scrolling always has a vertical delta -

Image
i've subclassed qgraphicsview custom canvas used in cad application. i've reimplemented qgraphicsview::wheelevent check keyboard modifiers control key and, if control key pressed, zoom. i'm trying implement horizontal scroll when user holds shift , uses wheel. the problem i'm having horizontal scrolling always scrolls 0.279. not huge problem, hugely annoying , points else being wrong. so, here questions: is right way implement horizontal scrolling? if not, is? how eliminate delta of 0.279? thanks in advance. code , sample output below void myview::zoom(int delta) { double factor = pow(1.2, delta/abs(delta)); this->scale(factor, factor); } void myview::scrollhorizontal(int level) { qpointf center = maptoscene(viewport()->rect().center()); qdebug() << "center: " << center.x() << ", " << center.y(); centeron(qpointf(center.x() - level, center.y())); } void myview::wheelevent(qwheeleve...
Read more