Insert Performance

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.

Database OptimizationInsert PerformanceMyBatis

0 likes · 10 min read

Boost MySQL Insert Performance with Batch Techniques and MyISAM

IT Xianyu

Jun 1, 2021 · Databases

Improving MySQL Insert Performance with Multithreading, Prepared Statements, and Batch Transactions

The article explains why multithreaded inserts can be faster than single‑threaded ones in MySQL, breaks down the time spent on each step of an insert operation, and presents practical techniques such as using PreparedStatement, multi‑value INSERT statements, and transaction batching to dramatically reduce insertion time.

Batch TransactionDatabase OptimizationInsert Performance

0 likes · 6 min read

Improving MySQL Insert Performance with Multithreading, Prepared Statements, and Batch Transactions