tags:

views:

47

answers:

1
+1  Q: 

Compiled Queries and Sequence Parameters

I know I can't use something like int[] or list as a parameter to a compiled query, but I need to find someway get the performance benefits of a compiled query that accepts n number of integers as a parameter.

Has anyone found any work arounds or alternative solutions to this issue?

A: 

Have you tried using a fixed size array, i.e. int[10] ?

Larry Watanabe  2009-09-14 13:38:41
I thought about that but I never really know how large the collection is going to be. Would it be bad for to just predefine the array parameter with an high capacity, say int[100]?
Antilogic  2009-09-14 13:44:27
I think it will be a good workaround, as long as you are sure that 100 is high enough and that you explicitly check for out-of-range and log a system error in case it ever occurs. 100 ints is going to be a trivial amount of memory and will not affect run-time performance, whereas compiling the query will definitely improve run-time performance. So, you will have a performance improvement, but a potential problem if you ever hit that limit, so be sure to log it and make sure it is easy to track down in case your program ends up running for a long time and your grandson has to debug it :)(
Larry Watanabe  2009-09-14 14:46:20

related questions

Displaying Flash content in a C# WinForms application
How to get the value of built, encoded ViewState?
Unhandled Exception Handler in .NET 1.1
How do I connect to a database and loop over a recordset in C#?
How do I most elegantly express left join with aggregate SQL as LINQ query
Get a new object instance from a Type in C#
.NET Testing Framework Advice
Automatically update version number
What is the difference between an int and an Integer in Java/C#?
How to write to Web.Config in Medium Trust ?
WinForms ComboBox data binding gotcha
How do you sort a C# dictionary by value?
Adding Scripting functionality to .NET applications
Floating Point Number parsing: Is there a Catch All algorithm?
How do I print an HTML document from a web service?
Decoding T-SQL CAST in C#/VB.net
Anatomy of a "Memory Leak"
How do I get a distinct, ordered list of names from a DataTable using Linq
Reliable Timer in a Console Application
How do I fill a DataSet or a DataTable from a LINQ query resultset ?
What's the difference between Math.Floor() and Math.Truncate() in .NET?
How do I calculate relative time?
How do I calculate someone's age in C#?
Are there any conversion tools for porting Visual J# code to C#?
When setting a form's opacity should I use a decimal or double?