blog<\/a>.
\nNow create object of User domain and save it.<\/p>\n[code]
\nUser user = new User(firstName: ‘Deepak’, lastName: ‘Mittal’, emailId: ‘deepak.krmittal@intelligrape.com’)
\nuser.save(flush: true)
\n[\/code]
\nIn case, your unique validation pass and\u00a0if you check your console, then there are 3 queries triggered by grails application :<\/p>\n
[code]<\/p>\n
Hibernate: select this_.id as id1_3_0_, this_.version as version2_3_0_, this_.email_id as email_id3_3_0_, this_.first_name as first_na4_3_0_, this_.last_name as last_nam5_3_0_ from user this_ where this_.email_id=?
\nHibernate: select this_.id as id1_3_0_, this_.version as version2_3_0_, this_.email_id as email_id3_3_0_, this_.first_name as first_na4_3_0_, this_.last_name as last_nam5_3_0_ from user this_ where this_.email_id=?
\nHibernate: insert into user (version, email_id, first_name, last_name) values (?, ?, ?, ?)<\/p>\n
[\/code]<\/p>\n
This might be a bug but we can fix it as well using following solution code:<\/p>\n
[code]<\/p>\n
User user = new User(firstName: ‘Deepak’, lastName: ‘Mittal’, emailId: ‘deepak.krmittal@intelligrape.com’)<\/p>\n
if(user.validate() && user.save(flush: true, validate: false)) {
\n println(‘Success’)
\n} else {
\n println(‘Error’)
\n}<\/p>\n
[\/code]<\/p>\n
When you run this code, then this will trigger only 2 queries like:<\/p>\n
[code]<\/p>\n
Hibernate: select this_.id as id1_3_0_, this_.version as version2_3_0_, this_.email_id as email_id3_3_0_, this_.first_name as first_na4_3_0_, this_.last_name as last_nam5_3_0_ from user this_ where this_.email_id=?
\nHibernate: insert into user (version, email_id, first_name, last_name) values (?, ?, ?, ?)<\/p>\n
[\/code]<\/p>\n
Now your purpose is solved with a little bit optimized code. We can further optimize this code in the next blog.<\/p>\n
Code written with Grails 2.4.3.<\/p>\n","protected":false},"excerpt":{"rendered":"
Grails unique constraint is very powerful way to check duplicate keys in any DBMS, but it has some impact on application performance. Lets check it by one example: Suppose we have one domain having the following structure: [code] class User { String firstName String lastName String emailId static constraints = { emailId nullable: false, blank: […]<\/p>\n","protected":false},"author":145,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":9},"categories":[7],"tags":[29,1576,1579,1577,442,648,1578],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts\/16436"}],"collection":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/users\/145"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/comments?post=16436"}],"version-history":[{"count":0,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts\/16436\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/media?parent=16436"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/categories?post=16436"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/tags?post=16436"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}