Migration from Classic ASP to ASP.NET - Large Social Networking Website

A start-up faced with the 'good' type problem - an ever growing user base - called on ANUJ Technologies to address their performance issues.

The Challenge

• Investigate bottlenecks in current ASP code and SQLServer database - causing the production site to come to a crawl.
• Develop and implement a migration plan for taking the ASP code to ASP.NET - without affecting the existing production site.

The Solution

• 1) Starting with the SQLServer database - ANUJ Technologies identified various bottlenecks. These included - poorly designed queries, missing or incorrect indices, excessive memory usage and excessive disk usage causing high CPU Utilization.
• 2) Transaction logs sizes were shrunk to manageable sizes. Each query was re-written, several new indices encompassing multiple columns were created. A maintenance plan encompassing re-building of fragmented indices, backing up and shrinking of large transaction logs was implemented.
• 3) Code Cleanup - A lot of database access code was duplicated in various ASP files. These were all separated into a common data access layer - using efficient ADO.NET datasets and datatables.
• 4) Common UI elements were identified and custom user controls were created. These common controls were then used across various web pages - allowing a significant performance improvement in page-load times.

The Results

• Moved Varsity Media Group from a relatively slow performing community website to among the top 10 percentile – by identifying and cleaning up software related bottlenecks.
• Provided a faster and cleaner web navigation experience for end users.
• Increased monthly user subscriptions due to improved website performance.