{"id":18119,"date":"2024-03-15T16:16:42","date_gmt":"2024-03-15T16:16:42","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/what-is-the-efficiency-of-batch-updates-in-mybatis-plus\/"},"modified":"2024-03-21T12:32:49","modified_gmt":"2024-03-21T12:32:49","slug":"what-is-the-efficiency-of-batch-updates-in-mybatis-plus","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/what-is-the-efficiency-of-batch-updates-in-mybatis-plus\/","title":{"rendered":"What is the efficiency of batch updates in MyBatis Plus?"},"content":{"rendered":"

MyBatis Plus offers the updateBatchById method to achieve batch update operations, which can improve update efficiency.<\/p>\n

When using the updateBatchById method, you need to pass in a collection of entity objects to indicate the data to be updated. MyBatis Plus will automatically update the corresponding data based on the primary key of the entity object.<\/p>\n

Here is an example:<\/p>\n

List<User> userList = new<\/span> ArrayList<\/span><>();\r\n\/\/ \u5047\u8bbe\u8981\u66f4\u65b0\u7684\u6570\u636e\u5df2\u7ecf\u67e5\u8be2\u51fa\u6765\u5e76\u6dfb\u52a0\u5230 userList \u4e2d<\/span>\r\n\/\/ ...<\/span>\r\n\r\n\/\/ \u4f7f\u7528 updateBatchById \u65b9\u6cd5\u8fdb\u884c\u6279\u91cf\u66f4\u65b0<\/span>\r\nboolean<\/span> success<\/span> =<\/span> userService.updateBatchById(userList);\r\nif<\/span> (success) {\r\n    \/\/ \u66f4\u65b0\u6210\u529f<\/span>\r\n} else<\/span> {\r\n    \/\/ \u66f4\u65b0\u5931\u8d25<\/span>\r\n}\r\n<\/code><\/pre>\n
\u6ce8\u610f\u4e8b\u9879\uff1a<\/p>\n
Important points to note:<\/p>\n
    \n
  1. update a batch of records by their IDs<\/li>\n
  2. update multiple batches by their IDs<\/li>\n
  3. choose the batch IDs<\/li>\n
  4. If the amount of data to be updated is large, it may affect the performance of the database. It is recommended to consider updating in batches or using other methods to improve efficiency based on the specific situation.<\/li>\n<\/ol>\n
    In general, using the updateBatchById method makes it convenient to implement batch update operations and enhances the efficiency of updates.<\/p>\n","protected":false},"excerpt":{"rendered":"
    MyBatis Plus offers the updateBatchById method to achieve batch update operations, which can improve update efficiency. When using the updateBatchById method, you need to pass in a collection of entity objects to indicate the data to be updated. MyBatis Plus will automatically update the corresponding data based on the primary key of the entity object. […]<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-18119","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\nWhat is the efficiency of batch updates in MyBatis Plus? - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/what-is-the-efficiency-of-batch-updates-in-mybatis-plus\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is the efficiency of batch updates in MyBatis Plus?\" \/>\n<meta property=\"og:description\" content=\"MyBatis Plus offers the updateBatchById method to achieve batch update operations, which can improve update efficiency. When using the updateBatchById method, you need to pass in a collection of entity objects to indicate the data to be updated. MyBatis Plus will automatically update the corresponding data based on the primary key of the entity object. […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/what-is-the-efficiency-of-batch-updates-in-mybatis-plus\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-15T16:16:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-21T12:32:49+00:00\" \/>\n<meta name=\"author\" content=\"Olivia Parker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Olivia Parker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-efficiency-of-batch-updates-in-mybatis-plus\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-efficiency-of-batch-updates-in-mybatis-plus\/\"},\"author\":{\"name\":\"Olivia Parker\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9\"},\"headline\":\"What is the efficiency of batch updates in MyBatis Plus?\",\"datePublished\":\"2024-03-15T16:16:42+00:00\",\"dateModified\":\"2024-03-21T12:32:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-efficiency-of-batch-updates-in-mybatis-plus\/\"},\"wordCount\":149,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-efficiency-of-batch-updates-in-mybatis-plus\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-efficiency-of-batch-updates-in-mybatis-plus\/\",\"name\":\"What is the efficiency of batch updates in MyBatis Plus? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T16:16:42+00:00\",\"dateModified\":\"2024-03-21T12:32:49+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-efficiency-of-batch-updates-in-mybatis-plus\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/what-is-the-efficiency-of-batch-updates-in-mybatis-plus\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-efficiency-of-batch-updates-in-mybatis-plus\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What is the efficiency of batch updates in MyBatis Plus?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9\",\"name\":\"Olivia Parker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g\",\"caption\":\"Olivia Parker\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/oliviaparker\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"What is the efficiency of batch updates in MyBatis Plus? - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/blog\/what-is-the-efficiency-of-batch-updates-in-mybatis-plus\/","og_locale":"en_US","og_type":"article","og_title":"What is the efficiency of batch updates in MyBatis Plus?","og_description":"MyBatis Plus offers the updateBatchById method to achieve batch update operations, which can improve update efficiency. When using the updateBatchById method, you need to pass in a collection of entity objects to indicate the data to be updated. MyBatis Plus will automatically update the corresponding data based on the primary key of the entity object. […]","og_url":"https:\/\/www.silicloud.com\/blog\/what-is-the-efficiency-of-batch-updates-in-mybatis-plus\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T16:16:42+00:00","article_modified_time":"2024-03-21T12:32:49+00:00","author":"Olivia Parker","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Olivia Parker","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-efficiency-of-batch-updates-in-mybatis-plus\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-efficiency-of-batch-updates-in-mybatis-plus\/"},"author":{"name":"Olivia Parker","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9"},"headline":"What is the efficiency of batch updates in MyBatis Plus?","datePublished":"2024-03-15T16:16:42+00:00","dateModified":"2024-03-21T12:32:49+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-efficiency-of-batch-updates-in-mybatis-plus\/"},"wordCount":149,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-efficiency-of-batch-updates-in-mybatis-plus\/","url":"https:\/\/www.silicloud.com\/blog\/what-is-the-efficiency-of-batch-updates-in-mybatis-plus\/","name":"What is the efficiency of batch updates in MyBatis Plus? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T16:16:42+00:00","dateModified":"2024-03-21T12:32:49+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-efficiency-of-batch-updates-in-mybatis-plus\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/what-is-the-efficiency-of-batch-updates-in-mybatis-plus\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-efficiency-of-batch-updates-in-mybatis-plus\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"What is the efficiency of batch updates in MyBatis Plus?"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9","name":"Olivia Parker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g","caption":"Olivia Parker"},"url":"https:\/\/www.silicloud.com\/blog\/author\/oliviaparker\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/18119","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=18119"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/18119\/revisions"}],"predecessor-version":[{"id":51777,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/18119\/revisions\/51777"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=18119"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=18119"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=18119"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}