Optimizing SQL Queries With JPA Repositoriesby@dstepanov
341 reads

Optimizing SQL Queries With JPA Repositories

tldt arrow
Read on Terminal Reader

Too Long; Didn't Read

Developers created one entity class and one repository for each table in the relational data model. Over time, the volume of data grew, entities acquired additional fields, and the number of connections increased. At this point, the developers decided to write native SQL queries to improve performance. This created architectural problems since such queries often use the features of a particular SQL dialect for optimization. They are not validated during the build of the project and their maintenance in a working state depended on the responsibility of specific developers. There is another option, allocate a separate class for a shortened ViewModel that is read-only.

Company Mentioned

Mention Thumbnail
featured image - Optimizing SQL Queries With JPA Repositories
Stepanov Dmitrii HackerNoon profile picture

@dstepanov

Stepanov Dmitrii

About @dstepanov
LEARN MORE ABOUT @DSTEPANOV'S EXPERTISE AND PLACE ON THE INTERNET.
react to story with heart
Stepanov Dmitrii HackerNoon profile picture
by Stepanov Dmitrii @dstepanov.10+ years of experience in software development including architecture, design, implementation, and maintenance.
Read My Stories

RELATED STORIES

L O A D I N G
. . . comments & more!
Hackernoon hq - po box 2206, edwards, colorado 81632, usa