BestHub
Sign in
Tagged articles
101 articles
Page 1 of 2
IT Services Circle
IT Services Circle
Apr 29, 2026 · Backend Development

10 Common MyBatis-Plus Pitfalls and How to Avoid Them

This article analyzes ten frequent pitfalls when using MyBatis-Plus—such as incorrect pagination totals, pagination plugin misconfiguration, logical delete failures, auto‑fill issues, optimistic‑lock mismatches, null handling in QueryWrapper, batch‑insert performance, enum mapping errors, wrapper condition overrides, and type‑handler problems—provides root‑cause explanations, concrete code examples, and practical solutions to help developers write more robust and efficient Java backend code.

Batch InsertEnum MappingJava
0 likes · 19 min read
10 Common MyBatis-Plus Pitfalls and How to Avoid Them
Java Backend Technology
Java Backend Technology
Apr 28, 2026 · Backend Development

10 Common MyBatis-Plus Pitfalls and How to Avoid Them

This article examines ten frequent pitfalls when using MyBatis-Plus—such as incorrect pagination counts, disabled pagination, logical‑delete mishandling, auto‑fill failures, optimistic‑lock issues, batch‑insert slowness, enum mapping errors, JSON type‑handler problems, and query‑wrapper quirks—explains their causes, and provides concrete code‑level solutions and best‑practice recommendations.

Batch InsertEnum MappingJSON TypeHandler
0 likes · 18 min read
10 Common MyBatis-Plus Pitfalls and How to Avoid Them
Su San Talks Tech
Su San Talks Tech
Apr 27, 2026 · Backend Development

10 Common Pitfalls in MyBatis-Plus and How to Avoid Them

The article enumerates ten typical traps when using MyBatis-Plus—such as incorrect pagination counts, ineffective pagination plugins, logical delete mishandling, auto‑fill failures, optimistic‑lock issues, null‑value conditions, batch‑insert slowness, enum mapping errors, wrapper overwrites, and type‑handler problems—explains why they occur, and provides concrete code‑level solutions and best‑practice recommendations.

Batch InsertEnum MappingJava
0 likes · 19 min read
10 Common Pitfalls in MyBatis-Plus and How to Avoid Them
Java Architect Handbook
Java Architect Handbook
Feb 3, 2026 · Backend Development

Speeding Up 100k MySQL Inserts: From 5 Minutes to 3 Seconds in Java

This article walks through a real‑world data‑migration case where 100,000 rows were moved from an old system to a new one, showing how naive per‑row inserts took five minutes and how a series of optimizations—batch SQL, JDBC batch mode, and multithreaded parallelism—reduced the runtime to just three seconds, while also covering common pitfalls and the final high‑performance implementation.

Batch InsertJDBCJava
0 likes · 11 min read
Speeding Up 100k MySQL Inserts: From 5 Minutes to 3 Seconds in Java
java1234
java1234
Jan 30, 2026 · Backend Development

How to Reduce MyBatis Batch Insert from 5 Minutes to 3 Seconds? Three Key Optimizations

The article walks through three concrete optimizations—batch SQL, JDBC batch mode with rewriteBatchedStatements, and multithreaded parallel inserts—that shrink a 100,000‑row MyBatis insertion from five minutes to three seconds, while highlighting configuration details, performance gains, and common pitfalls.

Batch InsertJDBCJava
0 likes · 10 min read
How to Reduce MyBatis Batch Insert from 5 Minutes to 3 Seconds? Three Key Optimizations
Java Companion
Java Companion
Jan 29, 2026 · Backend Development

How to Cut MyBatis Batch Insert Time from 5 Minutes to 3 Seconds: Three Key Optimizations

The article walks through turning a naïve MyBatis loop that took five minutes to insert 100,000 rows into a high‑performance solution that finishes in three seconds by applying batch SQL, JDBC batch mode with rewriteBatchedStatements, and multithreaded parallel execution, while highlighting pitfalls and best‑practice configurations.

Batch InsertExecutorType.BATCHJDBC
0 likes · 9 min read
How to Cut MyBatis Batch Insert Time from 5 Minutes to 3 Seconds: Three Key Optimizations
Senior Tony
Senior Tony
Dec 1, 2025 · Databases

How to Efficiently Import 100 Million Excel Rows into MySQL

This article explains how to import a hundred‑million‑row Excel dataset into MySQL by using CSV format, streaming parsers like EasyExcel, batch inserts, asynchronous processing, and partial‑transaction strategies to ensure feasibility, data integrity, and high performance.

Batch InsertExcelStreaming
0 likes · 5 min read
How to Efficiently Import 100 Million Excel Rows into MySQL
Architecture Digest
Architecture Digest
Sep 16, 2025 · Databases

How to Insert 300,000 Records Efficiently with MyBatis and JDBC

This article demonstrates how to insert 300,000 rows into a MySQL table using MyBatis and JDBC, compares naïve single‑batch and per‑row approaches, presents optimized batch‑processing code with configurable batch sizes and wait times, and shares practical performance‑tuning tips such as index handling and connection‑pool configuration.

Batch InsertJDBCMyBatis
0 likes · 14 min read
How to Insert 300,000 Records Efficiently with MyBatis and JDBC
Tencent Cloud Developer
Tencent Cloud Developer
Sep 3, 2025 · Databases

Deep Dive into GORM: Architecture, Internals, and Common Pitfalls

This article provides a comprehensive overview of Go's powerful GORM ORM library, covering its core concepts, architecture, internal logic, common pitfalls, practical tips, and advanced features such as soft deletes, transaction handling, batch operations, and integration with trpc-go, helping developers master GORM's inner workings.

Batch InsertGORMGo
0 likes · 26 min read
Deep Dive into GORM: Architecture, Internals, and Common Pitfalls
Tech Freedom Circle
Tech Freedom Circle
Jul 15, 2025 · Databases

One‑Order Four‑Split: Solving MySQL Deadlocks in Million‑Row Imports

During massive daily imports of up to one million reconciliation records, MySQL deadlocks can cripple performance; this article dissects the four classic deadlock conditions, then presents a systematic “One‑Order Four‑Split” strategy—ordered writes, transaction splitting, index management, partitioning, and gap‑lock removal—backed by benchmarks, code samples, and configuration tweaks that cut lock rates by up to 90% and reduce batch times to under ten minutes.

Batch InsertIndex OptimizationJava
0 likes · 27 min read
One‑Order Four‑Split: Solving MySQL Deadlocks in Million‑Row Imports
Architect's Tech Stack
Architect's Tech Stack
Jul 7, 2025 · Databases

Boost MyBatis Batch Inserts: Why foreach Slows Down and How to Fix It

This article explains why using MyBatis foreach for bulk inserts can cause severe performance degradation, analyzes the underlying parsing and executor issues, and provides practical solutions such as using ExecutorType.BATCH and limiting batch sizes to achieve fast, reliable batch insertion.

Batch InsertExecutorType.BATCHMyBatis
0 likes · 8 min read
Boost MyBatis Batch Inserts: Why foreach Slows Down and How to Fix It
Su San Talks Tech
Su San Talks Tech
Jun 25, 2025 · Databases

Why MyBatis‑Plus saveBatch Is Slow and How to Speed It Up 30×

This article analyzes the poor performance of MyBatis‑Plus saveBatch, compares it with single inserts, manual SQL batching, and JDBC executeBatch, and shows how enabling the rewriteBatchedStatements flag can dramatically improve batch insert speed.

Batch InsertJDBCmybatis-plus
0 likes · 10 min read
Why MyBatis‑Plus saveBatch Is Slow and How to Speed It Up 30×
Code Ape Tech Column
Code Ape Tech Column
May 9, 2025 · Databases

Efficient Strategies for Importing One Billion Records into MySQL

This article explains how to import 1 billion 1 KB log records stored in HDFS or S3 into MySQL by analyzing single‑table limits, using batch inserts, choosing storage engines, sharding, optimizing file‑reading methods, and coordinating distributed tasks with Redis, Redisson, and Zookeeper to ensure ordered, reliable, and high‑throughput data loading.

Batch InsertDistributed SystemsKafka
0 likes · 19 min read
Efficient Strategies for Importing One Billion Records into MySQL
Java Tech Enthusiast
Java Tech Enthusiast
May 5, 2025 · Backend Development

Advanced MyBatis-Plus Features: Batch Insert, Logical Delete, Auto Field Fill, Type Handlers, Dynamic Table Names, Multi-Tenant

The article demonstrates advanced MyBatis‑Plus techniques—including high‑speed batch inserts with rewriteBatchedStatements, logical deletes via global config, automatic timestamp and user fields through MetaObjectHandler, JSON serialization with JacksonTypeHandler, dynamic table naming via an interceptor, and a brief multi‑tenant overview—to streamline development and reduce boilerplate code.

Batch InsertDynamic TableJava
0 likes · 16 min read
Advanced MyBatis-Plus Features: Batch Insert, Logical Delete, Auto Field Fill, Type Handlers, Dynamic Table Names, Multi-Tenant
Java Tech Enthusiast
Java Tech Enthusiast
Feb 9, 2025 · Databases

Optimizing Database Insert Operations and Batch Insertion Strategies

The article explains how inserts work in relational databases, why fixed‑size pages and batch transactions dramatically reduce I/O and lock contention, and provides practical MyBatis guidelines—using the foreach tag, ExecutorType.BATCH, and an appropriate batchSize while estimating memory and disk limits to choose an optimal batch size and commit only once.

Batch InsertMyBatismysql
0 likes · 12 min read
Optimizing Database Insert Operations and Batch Insertion Strategies
Java Web Project
Java Web Project
Jan 15, 2025 · Backend Development

Why MyBatis foreach Batch Inserts Stall and How to Speed Them Up with ExecutorType.BATCH

The article investigates a MyBatis batch‑insert job that consumes excessive CPU and takes 14 minutes, explains why the foreach‑generated giant INSERT statement is inefficient, and demonstrates how switching to ExecutorType.BATCH or MyBatis dynamic‑SQL batch support reduces the runtime to under two seconds.

Batch InsertExecutorType.BATCHJava
0 likes · 10 min read
Why MyBatis foreach Batch Inserts Stall and How to Speed Them Up with ExecutorType.BATCH
Architect
Architect
Dec 20, 2024 · Backend Development

Boost MyBatis-Plus Batch Inserts by 2000% with rewriteBatchedStatements and ID Pre‑Generation

By configuring MySQL’s rewriteBatchedStatements=true, pre‑generating primary keys, adjusting MyBatis executor settings, and employing asynchronous multithreaded batch inserts, this guide demonstrates how to accelerate MyBatis‑Plus saveBatch operations from seconds to milliseconds, achieving up to a 2000% performance gain in large‑scale data scenarios.

Batch InsertJavaPerformance Optimization
0 likes · 20 min read
Boost MyBatis-Plus Batch Inserts by 2000% with rewriteBatchedStatements and ID Pre‑Generation
Zhuanzhuan Tech
Zhuanzhuan Tech
Nov 28, 2024 · Backend Development

Boosting MyBatis-Plus Batch Insert Performance by 2000% with rewriteBatchedStatements and Pre‑Generated IDs

This article explains how to dramatically improve MyBatis-Plus batch insertion speed—up to 2000%—by enabling rewriteBatchedStatements, pre‑generating primary keys to handle foreign‑key relationships, applying proper JDBC batch settings, and using asynchronous multithreaded insertion with optimized connection‑pool and executor configurations.

Batch InsertID generationJDBC
0 likes · 21 min read
Boosting MyBatis-Plus Batch Insert Performance by 2000% with rewriteBatchedStatements and Pre‑Generated IDs
ITPUB
ITPUB
Nov 9, 2024 · Databases

Why MySQL Unique Indexes Still Allow Duplicates and How to Fix Them

This article explains why a MySQL 8 InnoDB table with a unique index can still store duplicate rows—especially when indexed columns contain NULL or when logical deletion is used—and presents several practical strategies, including status counters, timestamps, extra IDs, hash fields, and batch‑insert techniques, to enforce true uniqueness.

Batch InsertHash FieldInnoDB
0 likes · 14 min read
Why MySQL Unique Indexes Still Allow Duplicates and How to Fix Them
Architect's Tech Stack
Architect's Tech Stack
Nov 6, 2024 · Backend Development

Optimizing MyBatis Batch Insert Performance with ExecutorType.BATCH and Proper Value Chunking

This article explains why using MyBatis foreach for bulk inserts can cause severe performance degradation, analyzes the underlying cost of large prepared statements, and demonstrates how switching to ExecutorType.BATCH or limiting each INSERT to 20‑50 rows dramatically improves insertion speed.

Batch InsertExecutorType.BATCHJava
0 likes · 8 min read
Optimizing MyBatis Batch Insert Performance with ExecutorType.BATCH and Proper Value Chunking
Top Architect
Top Architect
Nov 2, 2024 · Backend Development

Optimizing MyBatis-Plus Batch Insert Performance with rewriteBatchedStatements and Multithreading

This article explains how to dramatically speed up MyBatis-Plus batch inserts by enabling the rewriteBatchedStatements JDBC property, creating custom batch insert/update methods, and applying multithreading, providing code examples, performance test results, and practical recommendations for handling large data synchronizations.

Batch InsertJavaPerformance Optimization
0 likes · 15 min read
Optimizing MyBatis-Plus Batch Insert Performance with rewriteBatchedStatements and Multithreading
Architect's Guide
Architect's Guide
Oct 31, 2024 · Databases

Designing an Efficient Pipeline for Importing One Billion Records into MySQL

This article presents a comprehensive engineering guide for importing one billion 1 KB unstructured log records stored in HDFS or S3 into MySQL, covering data sizing, B‑tree limits, batch insertion strategies, storage‑engine choices, sharding, file‑reading techniques, concurrency control, and reliable task coordination using Redis, Redisson, and Zookeeper.

Batch InsertPerformance OptimizationZooKeeper
0 likes · 17 min read
Designing an Efficient Pipeline for Importing One Billion Records into MySQL
Java Architect Essentials
Java Architect Essentials
Oct 29, 2024 · Backend Development

Optimizing Batch Insert Performance with MyBatis-Plus: Configuration, Custom Methods, and Multithreading

This article explains why MyBatis-Plus's saveBatch() can be slow for large data sets, shows how enabling rewriteBatchedStatements in the JDBC URL dramatically speeds up inserts, and demonstrates custom batch insert/update methods and multithreaded execution to further improve performance, complete with code examples and test results.

Batch InsertJavaPerformance Optimization
0 likes · 14 min read
Optimizing Batch Insert Performance with MyBatis-Plus: Configuration, Custom Methods, and Multithreading
Architect's Guide
Architect's Guide
Sep 5, 2024 · Databases

Strategies for Fast Import of 1 Billion Records into MySQL

To import one billion 1 KB log records stored in HDFS or S3 into MySQL efficiently, the article examines data partitioning, B‑tree index limits, batch insertion, storage engine choices, concurrency control, file‑reading methods, task scheduling with Redis, Redisson, and Zookeeper for reliable, ordered, high‑throughput loading.

Batch InsertData PartitioningZooKeeper
0 likes · 18 min read
Strategies for Fast Import of 1 Billion Records into MySQL
Top Architect
Top Architect
Aug 11, 2024 · Backend Development

Efficient Insertion of 300,000 Records Using MyBatis and JDBC

This article demonstrates how to efficiently insert 300,000 rows into a MySQL table by using MyBatis batch operations, JDBC batch processing, and various performance optimizations such as batch size tuning, transaction management, and connection pooling.

Batch InsertJDBCJava
0 likes · 17 min read
Efficient Insertion of 300,000 Records Using MyBatis and JDBC
Selected Java Interview Questions
Selected Java Interview Questions
Jul 12, 2024 · Backend Development

Efficient Large File Upload and Database Insertion with Spring Boot, Vue, and Multithreading

This article demonstrates how to implement a high‑performance file upload system using Vue's Element Plus component on the frontend and Spring Boot on the backend, comparing single‑row inserts, batch inserts, and a multithreaded producer‑consumer approach to dramatically reduce MySQL insertion time.

Batch InsertSpring BootVue
0 likes · 10 min read
Efficient Large File Upload and Database Insertion with Spring Boot, Vue, and Multithreading
Code Ape Tech Column
Code Ape Tech Column
Jun 14, 2024 · Databases

Designing an Efficient Import of 1 Billion Records into MySQL: Architecture, Batch Loading, Sharding, and Concurrency Control

This article analyzes how to import one billion 1 KB log records stored in HDFS or S3 into MySQL by evaluating single‑table limits, choosing storage engines, designing sharding, batch insertion, file‑reading strategies, task coordination, and distributed locking to achieve high‑throughput and ordered writes.

Batch Insertconcurrencydata import
0 likes · 19 min read
Designing an Efficient Import of 1 Billion Records into MySQL: Architecture, Batch Loading, Sharding, and Concurrency Control
FunTester
FunTester
May 29, 2024 · Databases

How Fast Can MySQL Write? Comparing Single-Row, Batch, and Multi-Row Inserts

This article evaluates MySQL single‑thread write performance by testing three insertion methods—continuous while‑loop inserts, JDBC batch processing, and multi‑row INSERT statements—detailing setup, code examples, and measured rows per minute to reveal their relative throughput and stability.

Batch InsertJDBCMulti-Row Insert
0 likes · 10 min read
How Fast Can MySQL Write? Comparing Single-Row, Batch, and Multi-Row Inserts
macrozheng
macrozheng
Apr 26, 2024 · Databases

Boost MySQL Insert Performance with Batch Techniques and MyISAM

This article explains how to dramatically improve MySQL insert speed by adjusting database settings, choosing the MyISAM engine, and applying batch insertion methods such as concatenated SQL, transaction‑wrapped inserts, and MyBatis‑Flex saveBatch, complete with test code and performance results.

Batch InsertDatabase OptimizationInsert Performance
0 likes · 10 min read
Boost MySQL Insert Performance with Batch Techniques and MyISAM
IT Services Circle
IT Services Circle
Apr 18, 2024 · Databases

Improving MySQL Insert Performance with Batch Operations and MyBatis Flex

This article explains how to boost MySQL insertion speed by adjusting server hardware, tuning database parameters, choosing the MyISAM engine, and especially applying three batch‑insert techniques—SQL concatenation, MyBatis‑Flex saveBatch, and manual transaction batching—while showing test results and configuration tips.

Batch InsertDatabase OptimizationMyBatis
0 likes · 8 min read
Improving MySQL Insert Performance with Batch Operations and MyBatis Flex
Java Tech Enthusiast
Java Tech Enthusiast
Apr 5, 2024 · Databases

Efficient Insertion of 300,000 Records Using MyBatis and JDBC

The article shows how to efficiently load 300,000 MySQL rows in Java by comparing MyBatis and plain-JDBC batch inserts, demonstrating that batching 1,000‑5,000 records per transaction with proper transaction control, connection pooling, and MySQL tuning reduces insertion time from hours to seconds.

Batch InsertJDBCJava
0 likes · 13 min read
Efficient Insertion of 300,000 Records Using MyBatis and JDBC
Top Architect
Top Architect
Mar 31, 2024 · Databases

Inserting 300,000 Records with MyBatis and JDBC: Batch vs Loop Approaches and Performance Optimization

This article demonstrates how to insert 300,000 rows into a MySQL table using MyBatis and JDBC, compares bulk batch insertion with per‑row looping, discusses packet size limits, transaction handling, performance metrics, and provides practical code snippets and optimization tips for efficient large‑scale data loading.

Batch InsertJDBCMyBatis
0 likes · 16 min read
Inserting 300,000 Records with MyBatis and JDBC: Batch vs Loop Approaches and Performance Optimization
ITPUB
ITPUB
Mar 29, 2024 · Databases

How to Import 1 Billion Records into MySQL at Lightning Speed

This guide explains how to efficiently load one billion 1‑KB log entries from HDFS or S3 into MySQL by analyzing B‑tree limits, using batch inserts, choosing the right storage engine, sharding tables, optimizing file reading, and coordinating tasks with Redis, Redisson, and Zookeeper.

Batch InsertBig DataDistributed Tasks
0 likes · 19 min read
How to Import 1 Billion Records into MySQL at Lightning Speed
dbaplus Community
dbaplus Community
Dec 10, 2023 · Databases

How to Import 1 Billion Records into MySQL in Record Time

This article outlines a comprehensive strategy for rapidly loading one billion 1 KB log records stored in HDFS or S3 into MySQL, covering data partitioning, B‑tree limits, batch inserts, storage‑engine selection, sharding, concurrent write control, efficient file reading, task coordination, fault‑tolerant progress tracking with Redis, and distributed locking with Redisson.

Batch InsertFile Readingdata sharding
0 likes · 20 min read
How to Import 1 Billion Records into MySQL in Record Time
Architect
Architect
Nov 28, 2023 · Databases

How to Import 1 Billion Records into MySQL Efficiently: Architecture & Performance Guide

This article walks through the full engineering process of importing a billion 1 KB log records into MySQL, covering data size calculations, B‑tree index limits, batch‑insert strategies, storage‑engine trade‑offs, fast file‑reading techniques, task coordination with Redis and Redisson, and distributed‑lock design using Zookeeper.

Batch InsertDistributed TasksPerformance Optimization
0 likes · 20 min read
How to Import 1 Billion Records into MySQL Efficiently: Architecture & Performance Guide
Architecture Digest
Architecture Digest
Nov 27, 2023 · Databases

Fast Import of 1 Billion Records into MySQL: Design, Performance, and Reliability Considerations

To import one billion 1 KB log records into MySQL efficiently, the article examines data size constraints, B‑tree index limits, batch insertion strategies, storage engine choices, file‑reading techniques, task coordination with Redis, Redisson semaphores, and distributed lock handling to ensure ordered, reliable, high‑throughput loading.

Batch InsertBig DataDistributed Systems
0 likes · 18 min read
Fast Import of 1 Billion Records into MySQL: Design, Performance, and Reliability Considerations
Top Architecture Tech Stack
Top Architecture Tech Stack
Nov 2, 2023 · Databases

Strategies for Efficiently Importing One Billion Records into MySQL

This article analyzes the constraints of loading one billion 1 KB log records from distributed storage into MySQL, evaluates single‑table limits, proposes batch‑insert, sharding, storage‑engine, file‑reading, and distributed‑task coordination techniques to achieve high‑speed, ordered, and reliable data ingestion.

Batch InsertJavadata import
0 likes · 18 min read
Strategies for Efficiently Importing One Billion Records into MySQL
Code Ape Tech Column
Code Ape Tech Column
Oct 18, 2023 · Databases

Efficient Strategies for Importing One Billion Records into MySQL

This article explains how to import 1 billion 1 KB log records stored in HDFS or S3 into MySQL by analyzing table capacity limits, choosing storage engines, designing batch inserts, coordinating file reading and writing, and handling task reliability with Redis, Redisson, and Zookeeper.

Batch InsertDistributed TasksPerformance Optimization
0 likes · 18 min read
Efficient Strategies for Importing One Billion Records into MySQL
Su San Talks Tech
Su San Talks Tech
Oct 1, 2023 · Backend Development

How to Efficiently Insert 300,000 Records with MyBatis and JDBC

This article demonstrates multiple approaches—including direct MyBatis batch, per‑row insertion, and JDBC batch processing—to insert 300,000 user records into a MySQL table, compares their performance, and provides practical optimization tips such as batch size tuning, waiting intervals, index handling, and connection‑pool configuration.

Batch InsertJDBCJava
0 likes · 12 min read
How to Efficiently Insert 300,000 Records with MyBatis and JDBC
Architect's Guide
Architect's Guide
Aug 16, 2023 · Backend Development

Inserting 300,000 Records into MySQL Using MyBatis and JDBC: Strategies and Performance Comparison

This article demonstrates how to insert 300,000 rows into a MySQL table using MyBatis and plain JDBC, compares direct batch insertion, per‑row insertion, and staged batch processing, and provides practical performance tips such as batch size, waiting intervals, index handling, and connection‑pool configuration.

Batch InsertJDBCJava
0 likes · 14 min read
Inserting 300,000 Records into MySQL Using MyBatis and JDBC: Strategies and Performance Comparison
Java Interview Crash Guide
Java Interview Crash Guide
Aug 5, 2023 · Databases

How to Efficiently Insert 300,000 Records with MyBatis and JDBC

This article demonstrates multiple approaches—including MyBatis batch inserts, per‑row inserts, and JDBC batch processing—to efficiently load 300,000 user records into a MySQL table, compares their performance, and provides practical optimization tips such as batch size, waiting intervals, and index handling.

Batch InsertJDBCJava
0 likes · 14 min read
How to Efficiently Insert 300,000 Records with MyBatis and JDBC
JavaEdge
JavaEdge
Jul 14, 2023 · Databases

How to Efficiently Insert 1,000 Records with MyBatis: Loop vs Batch

When interviewers ask how to insert a thousand rows with MyBatis, the answer isn’t just a simple Java for‑loop; you need to consider batch processing, disable autocommit, and understand MyBatis’s limits to choose the most reliable and performant approach.

Batch InsertJavaMyBatis
0 likes · 3 min read
How to Efficiently Insert 1,000 Records with MyBatis: Loop vs Batch
Code Ape Tech Column
Code Ape Tech Column
Jun 28, 2023 · Backend Development

Optimizing Large-Scale Excel Import in Java: From POI to EasyExcel with Caching, Batch Inserts, and Parallel Streams

This article details a step‑by‑step optimization of a high‑volume Excel import workflow in Java, covering the migration from raw POI to EasyPOI and EasyExcel, caching database lookups, using MySQL batch inserts, and leveraging parallel streams to reduce import time from minutes to under two minutes.

Batch InsertExcelJava
0 likes · 12 min read
Optimizing Large-Scale Excel Import in Java: From POI to EasyExcel with Caching, Batch Inserts, and Parallel Streams
Top Architect
Top Architect
Mar 27, 2023 · Backend Development

Three MyBatis Batch Insert Methods and Their Performance Comparison

The article explains three ways to perform batch inserts with MyBatis—ordinary single-row inserts, foreach‑based bulk inserts, and ExecutorType.BATCH—analyzes their SQL logs, performance bottlenecks, MySQL limits, and provides practical recommendations for large‑scale data insertion.

Batch InsertExecutorTypeJava
0 likes · 13 min read
Three MyBatis Batch Insert Methods and Their Performance Comparison
macrozheng
macrozheng
Mar 20, 2023 · Backend Development

Boost MyBatis Batch Insert Speed: Avoid foreach Pitfalls and Use ExecutorType.BATCH

This article explains why MyBatis foreach‑based batch inserts become extremely slow with thousands of rows, demonstrates how the generated giant SQL statement hurts performance, and shows how switching to ExecutorType.BATCH or limiting rows per INSERT dramatically reduces insertion time.

Batch InsertExecutorType.BATCHJava
0 likes · 9 min read
Boost MyBatis Batch Insert Speed: Avoid foreach Pitfalls and Use ExecutorType.BATCH
Code Ape Tech Column
Code Ape Tech Column
Mar 12, 2023 · Databases

Optimizing Batch Insert Performance in MyBatis‑Plus with a Custom SQL Injector

This article analyzes why MyBatis‑Plus's default saveBatch method does not achieve true batch insertion, explains how to enable JDBC batch mode with rewriteBatchedStatements, and demonstrates creating a custom SQL injector (InsertBatchSomeColumn) to perform real batch inserts, including performance test results showing significant speed improvements.

Batch InsertJavaPerformance Optimization
0 likes · 10 min read
Optimizing Batch Insert Performance in MyBatis‑Plus with a Custom SQL Injector
Java Architect Essentials
Java Architect Essentials
Jan 10, 2023 · Backend Development

MyBatis and MyBatis-Plus Batch Insert Techniques with Performance Comparison

This article presents five common batch‑insert approaches for MyBatis and MyBatis‑Plus—including a for‑loop, manual batch commit, collection‑based batch, saveBatch, and InsertBatchSomeColumn—provides complete code examples, configuration steps, and measured execution times to help Java backend developers choose the most efficient method.

Batch InsertMyBatisSpring Boot
0 likes · 11 min read
MyBatis and MyBatis-Plus Batch Insert Techniques with Performance Comparison
Top Architect
Top Architect
Dec 8, 2022 · Backend Development

Common MyBatis Batch Insert Techniques and Performance Comparison

This article presents a detailed overview of five commonly used MyBatis and MyBatis-Plus batch insertion methods, including code examples, configuration steps, and performance measurements for inserting ten thousand records, helping developers choose the most efficient approach for large‑scale data insertion in Java backend projects.

Batch InsertJavaMyBatis
0 likes · 11 min read
Common MyBatis Batch Insert Techniques and Performance Comparison
Selected Java Interview Questions
Selected Java Interview Questions
Dec 1, 2022 · Backend Development

Five Common Batch Insert Techniques for MyBatis and MyBatis‑Plus

This article presents and compares five practical batch‑insert methods for MyBatis and MyBatis‑Plus, covering preparation steps, code implementations, configuration details, and performance results, helping developers choose the most efficient approach for inserting large volumes of data in Java backend projects.

Batch InsertJavaMyBatis
0 likes · 9 min read
Five Common Batch Insert Techniques for MyBatis and MyBatis‑Plus
Programmer DD
Programmer DD
Sep 2, 2022 · Backend Development

Speed Up MyBatis Batch Inserts: Avoid foreach Pitfalls with ExecutorType.BATCH

An in‑depth guide explains why using MyBatis’s foreach for bulk inserts can cause severe performance degradation, especially with large tables, and demonstrates how switching to ExecutorType.BATCH or limiting batch sizes to 20‑50 rows dramatically reduces insertion time from minutes to seconds.

Batch InsertExecutorType.BATCHJava
0 likes · 10 min read
Speed Up MyBatis Batch Inserts: Avoid foreach Pitfalls with ExecutorType.BATCH
Java Captain
Java Captain
Aug 25, 2022 · Databases

Optimizing MyBatis Batch Inserts: Reducing CPU Usage and Improving Performance

The article explains why MyBatis foreach‑based batch inserts can cause extreme CPU usage and long execution times, demonstrates how combining multiple VALUES into a single INSERT or using ExecutorType.BATCH dramatically improves performance, and provides practical code examples and sizing recommendations.

Batch InsertExecutorType.BATCHMyBatis
0 likes · 8 min read
Optimizing MyBatis Batch Inserts: Reducing CPU Usage and Improving Performance
Liangxu Linux
Liangxu Linux
Jul 3, 2022 · Databases

What’s the Optimal Batch Size for MySQL Inserts? A Deep Performance Test

This article investigates how many rows should be inserted per batch in MySQL by measuring the impact of packet size limits, buffer pool usage, insert buffers, transaction handling and index structures, and it provides practical recommendations based on tests with millions of rows.

Batch Insertbuffer poolmax_allowed_packet
0 likes · 16 min read
What’s the Optimal Batch Size for MySQL Inserts? A Deep Performance Test
Top Architect
Top Architect
May 6, 2022 · Databases

Optimizing MySQL Batch Insert Performance: Determining the Ideal Batch Size

This article analyzes MySQL batch insertion by examining field size, max_allowed_packet limits, transaction overhead, buffer pool usage, and empirical tests with varying batch sizes, ultimately recommending a batch size around half of the max_allowed_packet for optimal throughput.

Batch Insertbuffer poolinsert buffer
0 likes · 14 min read
Optimizing MySQL Batch Insert Performance: Determining the Ideal Batch Size
Java High-Performance Architecture
Java High-Performance Architecture
Mar 24, 2022 · Databases

How to Efficiently Query Millions of Rows in MySQL: Pagination Tricks and Optimizations

This article walks through generating a 10‑million‑row MySQL table, inserting data with a fast batch script, measuring plain LIMIT pagination performance, and applying several optimization techniques—including sub‑queries, ID‑range filtering, and column selection—to dramatically reduce query time on large data sets.

Batch InsertSQL Optimizationmysql
0 likes · 9 min read
How to Efficiently Query Millions of Rows in MySQL: Pagination Tricks and Optimizations
Selected Java Interview Questions
Selected Java Interview Questions
Jan 22, 2022 · Databases

Optimizing MyBatis Batch Inserts with ExecutorType.BATCH and Controlled foreach Values

This article analyzes why MyBatis foreach‑based batch inserts become extremely slow with thousands of rows, explains the underlying SQL and PreparedStatement overhead, and demonstrates how switching to ExecutorType.BATCH or limiting foreach values to 20‑50 rows dramatically improves MySQL insertion performance.

Batch InsertExecutorType.BATCHJava
0 likes · 9 min read
Optimizing MyBatis Batch Inserts with ExecutorType.BATCH and Controlled foreach Values
Architect's Tech Stack
Architect's Tech Stack
Dec 16, 2021 · Databases

Optimizing MyBatis Batch Inserts with ExecutorType.BATCH and foreach Size Limits

This article explains why MyBatis batch inserts using a foreach loop can become extremely slow when inserting thousands of rows, analyzes the underlying cost of parsing large prepared statements, and presents practical solutions such as using ExecutorType.BATCH, limiting foreach batch size, and employing JDBC batch execution to achieve sub‑second performance.

Batch InsertDatabase PerformanceExecutorType.BATCH
0 likes · 8 min read
Optimizing MyBatis Batch Inserts with ExecutorType.BATCH and foreach Size Limits
Top Architect
Top Architect
Dec 4, 2021 · Databases

Optimizing MyBatis Batch Insert Performance with ExecutorType.BATCH and Foreach Limits

This article explains why MyBatis foreach batch inserts can become extremely slow when inserting thousands of rows, analyzes the underlying SQL and PreparedStatement overhead, and demonstrates how using ExecutorType.BATCH together with a limited batch size (20‑50 rows per statement) dramatically improves insertion speed.

Batch InsertDatabase PerformanceExecutorType.BATCH
0 likes · 9 min read
Optimizing MyBatis Batch Insert Performance with ExecutorType.BATCH and Foreach Limits
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Oct 15, 2021 · Backend Development

Comprehensive Guide to MyBatis Batch Insert: Three Methods, Performance Comparison, and Analysis

This article introduces three MyBatis batch insertion techniques—looped single inserts, MyBatis‑Plus batch inserts, and native SQL batch inserts—provides complete implementation code, performance test results for inserting 100,000 records, analyzes the causes of differences, and offers practical solutions to common pitfalls such as MySQL packet size limits.

Batch InsertJavaMyBatis
0 likes · 13 min read
Comprehensive Guide to MyBatis Batch Insert: Three Methods, Performance Comparison, and Analysis
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Sep 27, 2021 · Backend Development

Implementing Batch Insert with MyBatis-Plus in Java

This article explains how to improve database insertion performance in Java by replacing per‑iteration inserts with MyBatis‑Plus’s saveBatch method, detailing dependency setup, schema creation, entity, controller, service, and mapper code for efficient bulk operations.

BackendBatch InsertJava
0 likes · 8 min read
Implementing Batch Insert with MyBatis-Plus in Java
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
Sep 14, 2021 · Backend Development

How to Efficiently Batch Insert Data with Spring Boot and Elasticsearch

This guide demonstrates how to set up Spring Boot 2.3.12 with Elasticsearch 7.8, configure separate JPA and Elasticsearch repositories, and implement two batch insertion methods—using ElasticsearchRestTemplate and repository saveAll—while measuring performance, showing comparable execution times for inserting 10,000 records.

Backend DevelopmentBatch InsertElasticsearch
0 likes · 4 min read
How to Efficiently Batch Insert Data with Spring Boot and Elasticsearch
Programmer DD
Programmer DD
Aug 25, 2021 · Databases

How to Efficiently Insert Massive Data Without Duplicates in MySQL

This article explains several MySQL techniques—INSERT IGNORE, ON DUPLICATE KEY UPDATE, INSERT…SELECT WHERE NOT EXISTS, and REPLACE—plus a practical MyBatis batch‑insert example, to handle large‑scale data imports while preventing duplicate records.

Batch InsertMyBatisSQL
0 likes · 5 min read
How to Efficiently Insert Massive Data Without Duplicates in MySQL
Selected Java Interview Questions
Selected Java Interview Questions
Aug 23, 2021 · Backend Development

Optimizing Bulk Data Import into MySQL with MyBatis: From Simple List Insertion to Multi‑Threaded Batch Processing

This article demonstrates how to dramatically speed up importing tens of thousands of records into MySQL by evolving a naïve list‑to‑MySQL approach into grouped batch inserts and finally a multi‑threaded MyBatis solution, while also addressing packet size limits and configuration tweaks.

BackendBatch InsertJava
0 likes · 9 min read
Optimizing Bulk Data Import into MySQL with MyBatis: From Simple List Insertion to Multi‑Threaded Batch Processing
Top Architect
Top Architect
Jul 11, 2021 · Databases

Handling Duplicate Inserts in MySQL: Strategies and MyBatis Batch Example

The article discusses efficient ways to perform bulk inserts in MySQL while avoiding duplicate records, covering techniques such as INSERT IGNORE, ON DUPLICATE KEY UPDATE, INSERT…SELECT…WHERE NOT EXISTS, REPLACE INTO, and demonstrates a practical MyBatis implementation with a unique mobile_number constraint.

Batch InsertINSERT IGNOREMyBatis
0 likes · 5 min read
Handling Duplicate Inserts in MySQL: Strategies and MyBatis Batch Example
Top Architect
Top Architect
Jun 10, 2021 · Backend Development

Optimizing Large Excel Import Performance in Java Backend Applications

This article details a step‑by‑step optimization of a Java backend Excel import pipeline, covering requirement analysis, performance bottlenecks, caching strategies, batch insertion techniques, parallel processing, and practical code examples to reduce a 10‑minute import to under two minutes.

Batch InsertExcelJava
0 likes · 13 min read
Optimizing Large Excel Import Performance in Java Backend Applications
Programmer DD
Programmer DD
May 25, 2021 · Databases

Boost MySQL Insert Speed with Multithreading, Prepared Statements, and Batch Techniques

This article explains why multithreaded inserts into MySQL can outperform single‑threaded writes, breaks down the time spent on connection, parsing and insertion, and presents practical techniques such as prepared statements, batch processing, multi‑value inserts, and transaction batching that together can reduce insert time to seconds for massive data sets.

Batch InsertPrepared Statementsmultithreading
0 likes · 6 min read
Boost MySQL Insert Speed with Multithreading, Prepared Statements, and Batch Techniques
Code Ape Tech Column
Code Ape Tech Column
Mar 1, 2021 · Backend Development

Optimizing Large‑Scale Excel Import in Java: From POI to EasyExcel with Caching, Batch Inserts, and Parallel Streams

This article describes how to dramatically speed up the import of massive Excel files in a Java backend by replacing raw POI with EasyExcel, caching database lookups, using MySQL batch inserts, and employing parallel streams to achieve sub‑minute processing for hundreds of thousands of rows.

Batch InsertExcel ImportJava
0 likes · 12 min read
Optimizing Large‑Scale Excel Import in Java: From POI to EasyExcel with Caching, Batch Inserts, and Parallel Streams
Architect's Tech Stack
Architect's Tech Stack
Nov 4, 2020 · Databases

Optimizing MySQL Insert Performance with Multithreading, Prepared Statements, Batch Inserts, and Transactions

This article explains why multithreaded inserts into a single MySQL table can be faster than single-threaded inserts, analyzes the time distribution of insertion operations, and presents techniques such as prepared statements, multi-value inserts, batch execution, and transaction batching to significantly improve insert throughput.

Batch InsertInsert OptimizationPreparedStatement
0 likes · 6 min read
Optimizing MySQL Insert Performance with Multithreading, Prepared Statements, Batch Inserts, and Transactions
MaGe Linux Operations
MaGe Linux Operations
Oct 31, 2020 · Databases

Boost MySQL Insert Speed: 4 Proven Techniques Tested

This article explores four practical methods—batch inserts, transaction wrapping, ordered primary‑key insertion, and their combined use—to dramatically improve MySQL InnoDB insert performance, presents test results across various data volumes, and offers key configuration cautions.

Batch InsertIndex MaintenanceInsert Optimization
0 likes · 6 min read
Boost MySQL Insert Speed: 4 Proven Techniques Tested
Architect's Tech Stack
Architect's Tech Stack
Oct 27, 2019 · Databases

Optimizing MySQL Inserts with Multithreading, Prepared Statements, Batch and Transaction Techniques

This article explains how multithreaded inserts, prepared statements, multi‑value SQL, and batch transaction commits can dramatically improve MySQL insert performance by reducing connection overhead, parsing time, and network I/O, achieving insertion of 100 000 rows in roughly ten seconds.

Batch InsertPerformance OptimizationPreparedStatement
0 likes · 5 min read
Optimizing MySQL Inserts with Multithreading, Prepared Statements, Batch and Transaction Techniques
Programmer DD
Programmer DD
Sep 23, 2019 · Databases

Why Multi‑Threaded Inserts Outperform Single Thread in MySQL

This article explains how multithreaded inserts into a MySQL table can be faster than single‑threaded inserts by reducing connection and parsing overhead, and it details techniques such as prepared statements, multi‑value inserts, and batch transaction commits to boost performance.

Batch InsertPrepared Statementsmultithreading
0 likes · 5 min read
Why Multi‑Threaded Inserts Outperform Single Thread in MySQL
dbaplus Community
dbaplus Community
Mar 23, 2016 · Databases

Boost MySQL Insert Speed with Batch Inserts, Transactions, and Ordered Data

This article explains three practical techniques—batching multiple rows into a single INSERT, wrapping inserts in transactions, and inserting records in primary‑key order—to significantly improve MySQL InnoDB insert performance, backed by detailed test results and important configuration tips.

Batch InsertDatabase PerformanceInnoDB
0 likes · 7 min read
Boost MySQL Insert Speed with Batch Inserts, Transactions, and Ordered Data
21CTO
21CTO
Mar 20, 2016 · Databases

Boost MySQL Insert Speed: Batch Inserts, Transactions, and Ordered Data

This article explains how to dramatically improve MySQL insert performance by batching multiple rows in a single statement, wrapping inserts in transactions, and inserting records in primary‑key order, backed by detailed test results and practical configuration tips.

Batch InsertInsert OptimizationPerformance Testing
0 likes · 6 min read
Boost MySQL Insert Speed: Batch Inserts, Transactions, and Ordered Data