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
Post a Comment