{"id":16512,"date":"2014-12-30T09:58:40","date_gmt":"2014-12-30T04:28:40","guid":{"rendered":"https:\/\/2thenew.xyz\/blog\/?p=16512"},"modified":"2014-12-30T09:58:40","modified_gmt":"2014-12-30T04:28:40","slug":"grails-unique-constraint-optimization-part-2","status":"publish","type":"post","link":"https:\/\/2thenew.xyz\/blog\/grails-unique-constraint-optimization-part-2\/","title":{"rendered":"Grails unique constraint optimization part 2"},"content":{"rendered":"

In the previous blog\u00a0Grails performance optimization – Unique constraint<\/a>\u00a0we have optimized Grails unique constraint. Now in this blog\u00a0we will check another use case and will optimize unique constraint according to it. Suppose we have two domains having the following structure:<\/p>\n

[code]
\nclass Address {
\n String addressLine1
\n String addressLine2<\/p>\n

static constraints = {
\n }
\n}
\n[\/code]<\/p>\n

[code]
\nclass User {<\/p>\n

String firstName
\n String lastName
\n String emailId
\n Address address<\/p>\n

static constraints = {
\n address nullable: true, blank: false
\n emailId nullable: false, blank: true, email: true, unique: true
\n }<\/p>\n

static mapping = {
\n address fetch: ‘join’
\n }
\n}
\n[\/code]<\/p>\n

Now create user object and check the database queries triggered by grails application:<\/p>\n

[code]
\nUser user = new User(firstName: ‘Deepak’, lastName: ‘Mittal’, emailId: ‘deepak.krmittal@intelligrape.com’)
\nif(user.validate() && user.save(flush: true, validate: false)) {
\n println(‘Success’)
\n} else {
\n println(‘Error’)
\n}
\n[\/code]<\/p>\n

Check the application console, it has the queries like this:<\/p>\n

[code]
\nHibernate: select this_.id as id1_1_1_, this_.version as version2_1_1_, this_.address_id as address_3_1_1_, this_.email_id as email_id4_1_1_, this_.first_name as first_na5_1_1_, this_.last_name as last_nam6_1_1_, address2_.id as id1_0_0_, address2_.version as version2_0_0_, address2_.address_line1 as address_3_0_0_, address2_.address_line2 as address_4_0_0_ from user this_ left outer join address address2_ on this_.address_id=address2_.id where this_.email_id=?
\nHibernate: insert into user (version, address_id, email_id, first_name, last_name) values (?, ?, ?, ?, ?)
\n[\/code]<\/p>\n

In the first\u00a0query for unique check, there are 2 issues.<\/p>\n

    \n
  1. User domain is joined with address domain due to fetch join<\/strong> specified in user mapping closure, which really doesn’t needed in unique check.<\/li>\n
  2. All fields of user and address domain are fetched while there is no need of them.<\/li>\n<\/ol>\n

    To solve the issue, we have replaced\u00a0the unique constraint with custom validator like this:<\/p>\n

    [code]
    \nclass User {<\/p>\n

    String firstName
    \n String lastName
    \n String emailId
    \n Address address<\/p>\n

    static constraints = {
    \n address nullable: true, blank: false
    \n emailId nullable: false, blank: true, email: true, validator: { val, obj ->
    \n if (obj.id) {
    \n if (User.countByEmailIdAndIdNotEqual(val, obj.id)) {
    \n return "already.exist"
    \n }
    \n } else {
    \n if (User.countByEmailId(val)) {
    \n return "already.exist"
    \n }
    \n }
    \n }
    \n }<\/p>\n

    static mapping = {
    \n address fetch: ‘join’
    \n }
    \n}
    \n[\/code]<\/p>\n

    Now again create the user object and check your application console, it has the queries as shown below:<\/p>\n

    [code]
    \nHibernate: select count(*) as y0_ from user this_ where this_.email_id=?
    \nHibernate: insert into user (version, address_id, email_id, first_name, last_name) values (?, ?, ?, ?, ?)
    \n[\/code]<\/p>\n

    Now your purpose is solved with a little bit optimized code.<\/p>\n

    Code written with Grails 2.4.3.<\/p>\n","protected":false},"excerpt":{"rendered":"

    In the previous blog\u00a0Grails performance optimization – Unique constraint\u00a0we have optimized Grails unique constraint. Now in this blog\u00a0we will check another use case and will optimize unique constraint according to it. Suppose we have two domains having the following structure: [code] class Address { String addressLine1 String addressLine2 static constraints = { } } [\/code] […]<\/p>\n","protected":false},"author":145,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":10,"footnotes":""},"categories":[7,1],"tags":[29,4840,1576,1579,1589,1588],"class_list":["post-16512","post","type-post","status-publish","format-standard","hentry","category-grails","category-technology","tag-gorm","tag-grails","tag-grails-constraints","tag-grails-hibernate","tag-grails-performance-optimization","tag-grails-unique-constraints"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t