NCache allowed us to reduce the load on our database servers and prevent them from becoming a scalability bottleneck. We needed a long term solution that would move us away from just throwing more database servers at the problem. By using NCache as part of our custom session object, we noticed a 30 percent optimization in the database resource usage.
Country or Region:
Technology-Based Health Programs
Virgin HealthMiles, a member of Sir Richard Branson's famed Virgin Group, provides programs and technologies that engage an employers' workforce in good health. With a range of solutions and program integration capabilities for a range of needs, the company helps employers drive higher awareness and engagement, and better insight into and impact of all their employee health investments.
Customer Needs Met:
Alachisoft, a California based company provides NCache and StorageEdge. NCache is an inmemory distributed data cache that lets you cache application data and ASP.NET Session State to boost your application performance and scalability. StorageEdge speeds up SharePoint by externalizing BLOBs and caching BLOB and list data.
You can download a free 30-Day fully working trial of NCache from here.
12005 Ford Road, Suite 520
Dallas, TX 75234
US: +1 (214) 764-6933
UK: +44 207 993-8327
Virgin HealthMiles uses ASP.NET Web servers, middle tier application servers, and database servers to support its website. With the increasing amount of traffic coming to its website, the database servers were consistently being hit the hardest, according to Dhinsa. Interestingly while this traffic was creating a tremendous load on the database servers, a great portion of the data being accessed from the database was mostly identical for multiple visitors. Dhinsa explained, "For example, users access data about the challenges they have in progress and company-based information, among other pieces of data. They access this data over and again, and multiple users are accessing the same common data."
"During peak traffic hours, our site gets thousands of visitors per hour. With many users taking part in the same challenges or being part of the same employer group, the database is often running the same query and returning the same data over and over. At the number of users grew, we could see that this could be a potential bottleneck." Consequently, he added, "We wanted to ensure we scaled the platform to accommodate the forecasted growth and we needed a solution that would reduce the resource requirements on the database servers. In a clustered environment, we were fortunate to manage this initially by adding another database server to the cluster. But that wasn't efficient and definitely not financially sustainable. So we started exploring the option of distributed caching technology."
Virgin HealthMiles found NCache by Alachisoft to be the ideal solution for administering the challenges of rising traffic, as faced by many firms recently. Many company websites face the same scalability bottleneck issues when their ASP.NET applications are managing staggering loads of data requests. Many applications run in load balanced server farms and handle thousands of transactions per second and hundreds of thousands of concurrent users because their overall architecture is very scalable except for one weak link. And, this weak link is the database that is not scalable. As the saying goes, “the strength of any chain is only as strong as its weakest link.” Therefore, data access can easily become a major bottleneck toward scalability.
Dhinsa said, “Member traffic continued growing at a steady clip and we noticed our database servers were being affected the most. That led us to NCache to reduce the load on the database servers without having to keep throwing more database servers at preventing bottlenecks. We now use NCache to temporarily store all the common data that's used over and again. With this, a considerably large number of trips to the database are saved, which eliminates previous database retrieval and prevents traffic buildup bottlenecks.” He added that “Virgin HealthMiles doesn't use ASP.NET Session State object, but we're instead tracking user sessions through our own custom session object.” While they don't use NCache for session storage, per se, they have their custom session object implemented in the application. Part of the custom session object is stored in NCache for a certain amount of time with the cache validity for up to a minute. After which it expires and invalidates itself and then refreshes again from the database.