我们建立了企业/联络处软件,例如,管理订单、客户、存货等,见www.NET 3.5和2008服务器。
我们有各种报告,如:
现在,我们正在直接查询我们的业务数据库。 我们有时会遇到业绩问题,我想知道,通过优化我们查询数据库的方式,还是通过利用报告服务器或将亚洲开发银行复制到另一个服务器来解决这一问题。
您能否提出任何建议? 或者我能读到的任何资源?
非常感谢你的帮助。
谢谢。
首先,使用报告服务的人赢得了大的帮助,因为你停止对同一个数据库进行同样的询问,只有投放机将发生变化,可以通过
优化提问是我第一次尝试,因为它永远不会受到伤害,只能是一次好的工作。 如果这还不够,我将考虑仅读一个数据库,用于报告工作,如果你的报告能够得益于数据仓办法,则建造一个法律厅。 为此,必须安装分析服务。
国家安全局可以实际提供帮助,因为它已逐步支持取得成绩和报告。 见http://technet.microsoft.com/en-us/library/ms155927.aspx” rel=“nofollow noreferer”>Report Caching in Reporting Services。
As a learning experience I recently tried implementing Quicksort with 3 way partitioning in C#. Apart from needing to add an extra range check on the left/right variables before the recursive call, ...
I m the only developer in my company, and am getting along well as an autodidact, but I know I m missing out on the education one gets from working with and having code reviewed by more senior devs. ...
I have two EF entities. One has a property called HouseNumber. The other has two properties, one called StartHouseNumber and one called EndHouseNumber. I want to create a many to many association ...
I m using decimal type (.net), and I want to see if two numbers are equal. But I only want to be accurate to 10 decimal places. For example take these three numbers. I want them all to be equal. 0....
I m creating an STA version of the SynchronizationContext for use in Windows Workflow 4.0. I m wondering what to do about exceptions when Post-ing callbacks. The SynchronizationContext can be used ...
I ve got some code which sets up a datacontext. Often enough, the datacontext should be set to some underlying data collection, such as an ObservableCollection - but occasionally I d like to set it ...
I am building an application with C#. I managed to turn this into a single instance application by checking if the same process is already running. Process[] pname = Process.GetProcessesByName("...
NOTE I have asked the related question (with an accepted answer): How to combine DataTrigger and Trigger? I think I need to combine an EventTrigger and a DataTrigger to achieve what I m after: when ...
