255
down vote
accepted
Model-View-Presenter
In MVP, the Presenter contains the UI business logic for the View. All invocations from the View delegate directly to Presenter. The Presenter is also decoupled directly from the View and talks to it through an interface. This is to allow mocking of the View in a unit test. One common attribute of MVP is that there has to be a lot of two-way dispatching. For example, when someone clicks the “Save” button, the event handler delegates to the Presenter’s “OnSave” method. Once the save is completed, the Presenter will then call back the View through its interface so that the View can display that the save has completed.
MVC vs MVP
Custom Paging
Introduction
Developers and database administrators have long debated methods for paging recordset results from Microsoft SQL Server, trying to balance ease of use with performance. The simplest methods were less efficient because they retrieved entire datasets from SQL Server before eliminating records which were not to be included, while the best-performing methods handled all paging on the server with more complex scripting. The ROW_NUMBER() function introduced in SQL Server 2005 provides an efficient way to limit results relatively easily.
Paging Efficiency
Adding Row Number to SQL Output
Select
CONVERT(nvarchar(4), ROW_NUMBER() OVER (ORDER BY [Auditing].[AuditQuestion].[Text])) + ‘. ‘ + [Auditing].[AuditQuestion].[Text] AS AuditQuestionText
…..
Garbage Collector
Summary: The .NET garbage collector provides a high-speed allocation service with good use of memory and no long-term fragmentation problems. This article explains how garbage collectors work, then goes on to discuss some of the performance problems that might be encountered in a garbage-collected environment. (10 printed pages)
Applies to:
Microsoft® .NET Framework
Contents
Introduction
Simplified Model
Collecting the Garbage
Performance
Finalization
Conclusion
Introduction
In order to understand how to make good use of the garbage collector and what performance problems you might run into when running in a garbage-collected environment, it’s important to understand the basics of how garbage collectors work and how those inner workings affect running programs.
Delete Vs Truncate
There are two main keywords used for deleting data from a table: TRUNCATE and DELETE. Although each achieves the same result, the methods employed for each vastly differ. There are advantages, limitations, and consequences of each that you should consider when deciding which method to use. Solution
Deleting Data Using TRUNCATE TABLE