tag:blogger.com,1999:blog-11646261.post192422117395862273..comments2024-01-02T00:43:44.344-08:00Comments on OakLeaf Systems: Rico Mariani's DLinq Performance Tips (Part 2) and Compiled QueriesRoger Jennings (--rj)http://www.blogger.com/profile/01700526164060680385noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-11646261.post-42776650106056248842008-04-28T03:05:00.000-07:002008-04-28T03:05:00.000-07:00qcsglll车库门卷帘门伸缩门翻译公司道闸挡车器伸缩门货架货架货架货架货架电动伸缩门车库门自动车库...qcsglll<BR/><A HREF="http://www.fm3m.com" REL="nofollow">车库门</A><BR/><A HREF="http://www.fm3m.com" REL="nofollow">卷帘门</A><BR/><A HREF="http://www.fm3m.com" REL="nofollow">伸缩门</A><BR/><A HREF="http://www.pulunfanyi.com/" REL="nofollow">翻译公司</A><BR/><A HREF="http://www.lengate.com/products/barrier.html" REL="nofollow">道闸</A><BR/><A HREF="http://www.lengate.com/products/barrier.html" REL="nofollow">Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-11646261.post-57873425519729443072007-06-30T09:03:00.000-07:002007-06-30T09:03:00.000-07:00Hi, Anders,Not surprisingly, the performance boost...Hi, Anders,<BR/><BR/>Not surprisingly, the performance boost also decreases as the number of bytes per row increases. The previous tests were with 36-byte rows. I'm about to post some results with 158-byte (average) rows.<BR/><BR/>It will be interesting to see how Beta 2 enhancements alter the results.<BR/><BR/>--rjRoger Jennings (--rj)https://www.blogger.com/profile/01700526164060680385noreply@blogger.comtag:blogger.com,1999:blog-11646261.post-22446647546243586152007-06-30T01:51:00.000-07:002007-06-30T01:51:00.000-07:00That was btw. Anders Borum that wrote the precedin...That was btw. Anders Borum that wrote the preceding comment. Have to get some account established ..Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-11646261.post-53259685507498691042007-06-30T01:50:00.000-07:002007-06-30T01:50:00.000-07:00Hi!Have to admit that was one heck of a cliffhange...Hi!<BR/><BR/>Have to admit that was one heck of a cliffhanger by Matt and Rico. Hopefully we'll get the real numbers within a few days.<BR/><BR/>I'd like to comment on the reported 500% performance increase. As reported by Rico (and indicative of your own findings), the performance gain using compiled queries decrease as the number of rows in the result sets increase.<BR/><BR/>The performance Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-11646261.post-19414056868272156852007-06-28T12:35:00.000-07:002007-06-28T12:35:00.000-07:00Thanks Jomo, that is good news :)Thanks Jomo, that is good news :)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-11646261.post-80112254918510793172007-06-28T09:44:00.000-07:002007-06-28T09:44:00.000-07:00Thanks for the post and for pointing out the issue...Thanks for the post and for pointing out the issue with the sample code in the msdn article. I've opened a bug to get it fixed. <BR/><BR/>Just a note: Compiled queries are not bound to a particular datacontext. An intended usage is to compile a query once and use it across many DataContexts.<BR/><BR/>Jomo Fisher<BR/>LINQ to SQL TeamAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-11646261.post-22963372611715577832007-06-28T01:00:00.000-07:002007-06-28T01:00:00.000-07:00I haven't looked at Orcas beta 1 yet, so forgive m...I haven't looked at Orcas beta 1 yet, so forgive me if the question I'm going to ask is stupid.<BR/><BR/>A compiled query, isn't that query only valid within a live, created DataContext instance? If so, using compiled queries for this test is cheating. <BR/><BR/>the thing is this: When you compile this query, you can also keep a connection open and call Prepare on the command, and get very high Anonymousnoreply@blogger.com