Optimization of Web Applications Using Eager Loading

Abstract

Web applications are widely recognized as the building blocks of service-based applications. Performance of an application mainly depends on the components of web applications. All legal services like appointment, court cases, hearings, to-do list, notification, etc., are available online. When we fetch all the records and data related to those records in web applications, the number of queries increases, thereby increasing the query processing time and reducing the performance of the application. This project mainly focuses on optimizing the performance of web application using eager loading technique on a key-value database. One way to improve the performance is to reduce the number of SQL queries by implementing a cache layer in-between the web application and the database server. In eager loading, a query loads the associated entities as part of the query. This is achieved by using the include method. Most Object Relational Mappings (ORMs) are lazy loading enabled by default. Queries are issued for the parent record, followed by one query for each child record. Eager loading technique is introduced to deal with a greater number of queries, and key-value database is used to support caching. By making use of the previous logs, many web applications can be optimized. As a result, the performance of the web applications can be improved, and the users can get rapid responses to their queries.