O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

OLTP Shopping Cart Example

This next example features an Internet-based e-commerce implementation for a global health and vitamin retailer. At the center of this high-availability application is the shopping cart and a global ordering and fulfillment capability. Concurrent users are approximately 5,000 to 10,000 at any one time, and this application supports up to 50 million hits per day. A key to this application is that it is “stateless” and all database calls are extremely simple and shallow. This web-facing application is built on a JRUN application server (from Adobe), uses Microsoft’s Internet Information Services (IIS), and features SQL Server at the database layer (as shown in Figure 3.3).

FIGURE 3.3 E-commerce Internet application with ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required