CFP last date
20 December 2024
Reseach Article

Enhancing Application Performance through GORM Optimizations

by Soumya Sen Gupta, P. Govind Raj
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 58 - Number 20
Year of Publication: 2012
Authors: Soumya Sen Gupta, P. Govind Raj
10.5120/9402-3880

Soumya Sen Gupta, P. Govind Raj . Enhancing Application Performance through GORM Optimizations. International Journal of Computer Applications. 58, 20 ( November 2012), 48-51. DOI=10.5120/9402-3880

@article{ 10.5120/9402-3880,
author = { Soumya Sen Gupta, P. Govind Raj },
title = { Enhancing Application Performance through GORM Optimizations },
journal = { International Journal of Computer Applications },
issue_date = { November 2012 },
volume = { 58 },
number = { 20 },
month = { November },
year = { 2012 },
issn = { 0975-8887 },
pages = { 48-51 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume58/number20/9402-3880/ },
doi = { 10.5120/9402-3880 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T21:03:03.942312+05:30
%A Soumya Sen Gupta
%A P. Govind Raj
%T Enhancing Application Performance through GORM Optimizations
%J International Journal of Computer Applications
%@ 0975-8887
%V 58
%N 20
%P 48-51
%D 2012
%I Foundation of Computer Science (FCS), NY, USA
Abstract

GORM (Grails Object Relational Mapping) is an Object Relational Mapping Framework for the Grails web framework. Object Relational Mapping (ORM) frameworks reduce the problems arising out of the object-relational impedance mismatch between the object oriented design model and the relational database design. Unlike other ORM frameworks which require application programmers to configure a lot of XML files, GORM sits transparently between the application logic and the database relieving the programmer from maintaining any sort of configuration files. The default ORM provided by Grails through GORM introduces performance issues in a web application especially when it experiences large loads. This paper identifies problems faced when applying default GORM to application which includes the N+1 select problem, issues with handling one-to-many relationships, bulk insertions as well as problems related to bulk mail transfer and keeping the query cache unused. The paper also suggests optimization techniques which could be applied to each of the problems in order to improve the overall performance of a web application using GORM as its ORM solution.

References
  1. Roderic Geoffrey Galton Cattell. Object data management: object-oriented and extended relational database systems. Addison-Wesley Pub. Co. , 1994, pp. 122.
  2. Elizabeth J. O'Neil. "Hibernate and the entity data model (edm)," in Proceedings of the ACM SIGMOD international conference on Management of data, 2008.
  3. Wikipedia. [Online] 28 8 2012. http://en. wikipedia. org/wiki/List_of_object-relational_mapping_software.
  4. Robert Fischer. Grails Persistence with Gorm and Gsql. Apress, 2009.
  5. Christopher M. Judd, Joseph Faisal Nusairat, James Shingler. Beginning Groovy and Grails. Apress, 2008
  6. Erich Gamma, Ralph Johnson, John Vlissides, Richard Helm. Design Patterns: Elements of Reusable Object-Oriented Software. s. 1. Pearson Education.
  7. Graeme Rocher, Jeff Brown. The Definitive Guide to Grails. Apress. 2007, pp. 78-79.
  8. Christian Bauer, Gavin King. Java Persistence with Hibernate. s. l. : Manning Publications, 2009, pp. 588-589.
  9. C. J. Date, A. Kannan, S. Swamynathan. An Introduction to Database Systems. s. 1. : Pearson Education. 2009, pp. 345-346
  10. Paul J. Deitel, Harvey M. Deitel. Java for Programmers. s. 1. Pearson Education. 2012, pp. 606-607.
  11. Eric Pugh, Joseph D. Gradecki. Professional Hibernate. s. 1. : Wrox Publishing. 2004, pp. 215-216.
  12. Wikipedia. [Online] 28 8 2012. http://en. wikipedia. org/wiki/Simple_Mail_Transfer_Pro ocol.
  13. Grails. [Online] 28 8 2012. http://grails. org/plugin/asynchronous-mail
  14. [Sourceforge. [Online]. 28 8 2012. http://sourceforge. net/projects/p6spy/
Index Terms

Computer Science
Information Sciences

Keywords

ORM Grails GORM CRUD Hibermate