-
Creational Patterns
Creational design patterns abstract the instantiation process. They help make a system independent of how its objects are created, com...
-
Asp .Net Connection Polling
Setting up the TCP connection between your Web application and SQL Server can be an expensive operation. Developers at Microsoft have been able to take advantage of connection pooling for some time now, allowing them to reuse connections to the database. Rather than setting up a new TCP connection on each request, a new connection is set up only when one is not available in the connection pool. When the connection is closed, it is returned to the pool where it remains connected to the database, as opposed to completely tearing down that TCP connection.
-
J2EE Transaction
Transactions for J2EE are addressed by the Java Transaction Service (JTS) and Java Transaction API (JTA) specifications. The JTS specification defines five distinct players involved in transaction processing -
Benefits of Using Patterns
Patterns are often quite simple to use, though not always easy to understand. However, patterns can be difficult and time consuming to document, since this effort requires an examination of ...
-
When Not to Use Database Indexes
Small static data tables may be so small that the Database Optimizer will simply read those tables as a full table scan and ignore indexes altogether. Examine your small static data tables. Do they really need indexing?