How not to structure your database-backed web applications: a study of performance bugs in the wild
Abstract
Many web applications use databases for persistent data storage, and using Object Relational Mapping (ORM) frameworks is a common way to develop such database-backed web applications. Unfortunately, developing efficient ORM applications is challenging, as the ORM framework hides the underlying database query generation and execution. This problem is becoming more severe as these applications need to process an increasingly large amount of persistent data. Recent research has targeted specific aspects of performance problems in ORM applications. However, there has not been any systematic study to identify common performance anti-patterns in real-world such applications, how they affect resulting application performance, and remedies for them.
BibTeX
@inproceedings{Yang-al:ICSE18,
author = {Junwen Yang and
Pranav Subramaniam and
Shan Lu and
Cong Yan and
Alvin Cheung},
title = {How not to structure your database-backed web applications: a study of performance bugs in the wild},
booktitle = {ICSE},
pages = {800--810},
publisher = {{ACM}},
year = {2018},
}