why linq sql perform improved loyal sql query?


strange opening outcome, i have linq sql query uses several let statements several info looks this



    open iqueryable<systemnews> getsystemnews()
{
controlling (var t = new transactionscope(transactionscopeoption.required,
new transactionoptions { isolationlevel = system.transactions.isolationlevel.readuncommitted }))
{
var law = s _datacontext.systemnews
let member = getmemberinfo(s.memberid)
let integrity = getdetermination(s.determinationid.value)
let daimoku = getdaimoku(s.daimokuid.value)
let opening = getentry(s.entryid.value)
let encouragment = getencouragement(s.encouragementid.value)
name new systemnews
{
newsdate = s.newsdate,
memberid = s.memberid,
photoid = s.photoid.value,
determinationid = s.determinationid.value,
daimokuid = s.daimokuid.value,
entryid = s.entryid.value,
encouragementid = s.encouragementid.value,
member = new lazylist<members>(member),
integrity = new lazylist<determinations>(determination),
daimoku = new lazylist<memberdaimoku>(daimoku),
opening = new lazylist<memberentries>(entry),
support = new lazylist<memberencouragements>(encouragment),
isdeterminationcomplete = s.isdeterminationcomplete.value
};
relapse results;
}
}


i combined same thing (basically during slightest several info achieved this) sql view, linq sql returned law underneath 90 miliseconds where perspective returned same information indeed reduction info over 700 milliseconds. anyone explain this?



Comments

Popular posts from this blog

list macos calm editors formula editors

how i practical urls indicate .aspx pages asp.net deployed an iis? (preferably but iis)

jaxb - xjc - reworking generated typesafe enum category members