I have a CLR function thet returns IEnumberable (a table) and it has a FillRow function. I am return

microsoft.public.dotnet.framework

20 Nov 2007 3:40 AM

I have a CLR function thet returns IEnumberable (a table) and it has a
FillRow function. I am returning 10,000 integers from this function. Is
there any way that I can preallocate the resulting table or give SQL server
hint as to how many rows my function will return? It makes me cringe to
think that every time FillRow is called that sql may be doing some memory
allocation to make the resulting table bigger.

22 Nov 2007 11:36 AM

Alexander Vasilevsky

You can
1. To use temporary table
2. Sort your integers in FillRow function

http://www.alvas.net - Audio tools for C# and VB.Net developers

Show quote

"DR" <softwareengineer98***@yahoo.com> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: news:efQZzcyKIHA.4688@TK2MSFTNGP06.phx.gbl...
>I have a CLR function thet returns IEnumberable (a table) and it has a
>FillRow function. I am returning 10,000 integers from this function. Is
>there any way that I can preallocate the resulting table or give SQL server
>hint as to how many rows my function will return? It makes me cringe to
>think that every time FillRow is called that sql may be doing some memory
>allocation to make the resulting table bigger.
>