Print Page | Close Window

Compiled Queries

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce 2010
Forum Discription: For .NET 4.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=2640
Printed Date: 22-Jan-2026 at 5:03pm


Topic: Compiled Queries
Posted By: earle36
Subject: Compiled Queries
Date Posted: 27-Apr-2011 at 12:42pm
Hey guys,
 
I was just wondering if you support / plan to support compiled queries?
 
( http://msdn.microsoft.com/en-us/library/bb896297.aspx - http://msdn.microsoft.com/en-us/library/bb896297.aspx )
 
 
Sorry if this has been discussed elsewhere, I couldn't seem to find any information on where IdeaBlade stands with this.
 
Thanks,


Replies:
Posted By: robertg
Date Posted: 28-Apr-2011 at 11:07am
Earle36,

The support of compiled queries is on our roadmap, but we don't have a definite release scheduled for it yet. I'll let our developers know that you were asking about it, because such feedback from customers is always helpful in setting priorities.

We did, however, add a feature in 6.0.7 which is related. From the http://drc.ideablade.com/xwiki/bin/view/Documentation/607-release-notes - patch notes :

"An optimization was added that internally caches compiled local queries and reuses the compiled plan for subsequent executions. This means that if you hang onto a query object, any executions of that query against the local cache after the first may be much faster. The amount of improvement will be related to how long compilation of the query takes versus the time taken to execute the compiled Func<>. Expressions that involve small datasets, hence small execution times, tend to benefit the most."

-- Robert


Print Page | Close Window