We have roughly 5000 methods generated into C# that need to get assembled into DLLs and then put out as assmeblies in a SQL Server database. We then intend on creating user-defined functions to call many of these directly.
We can break these 5000 down into bundles and make about 10 DLLs, OR we can make 5000 DLLs. What are the concerns from a run-time perspective ?
If we go with 5000 DLLs, will an end user performing a few ad-hoc queries that use these user-defined functions experience poorer performance than if we had 10 large DLLs ?
Any input is appreciated. We'll be trying to assess the performance ourselves, but I'm looking for any stories about using large numbers of DLLs.
Thanks
Scott
? I'll let someone else comment on the possible performance implications, but I'd personally be more concerned with management. 5000 methods in a single DLL is definitely an issue because if you change one method you'll have to redeploy all of them. Likewise with 5000 DLLs; I think you should try to group related methods in their own DLLs so that you can deploy and update them together. -- Adam MachanicPro SQL Server 2005, available nowhttp://www..apress.com/book/bookDisplay.html?bID=457-- <Scott Flory@.discussions.microsoft.com> wrote in message news:b3ecc08c-4d63-43f2-a09c-3271eb35a8cf@.discussions.microsoft.com... We have roughly 5000 methods generated into C# that need to get assembled into DLLs and then put out as assmeblies in a SQL Server database. We then intend on creating user-defined functions to call many of these directly. We can break these 5000 down into bundles and make about 10 DLLs, OR we can make 5000 DLLs. What are the concerns from a run-time perspective ? If we go with 5000 DLLs, will an end user performing a few ad-hoc queries that use these user-defined functions experience poorer performance than if we had 10 large DLLs ? Any input is appreciated. We'll be trying to assess the performance ourselves, but I'm looking for any stories about using large numbers of DLLs. Thanks Scott
No comments:
Post a Comment