computer_science:databases:mysql:mysql_tips_trics

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
computer_science:databases:mysql:mysql_tips_trics [2021/03/07 17:11] – [Use Transactions] carlossousacomputer_science:databases:mysql:mysql_tips_trics [2023/12/01 12:07] (current) – external edit 127.0.0.1
Line 49: Line 49:
 ===== Use Transactions for bulk insert: ===== ===== Use Transactions for bulk insert: =====
  
-**Pros:** Visibility of new data mid insert. Only one re-index, at the end of the transaction.+**Pros:** Only one re-index, at the end of the transaction.
  
-**Cons: **-+**Cons: **Visibility of new data only after commit - this can be considered an upside -.
  
 **Usage:** **Usage:**
  • computer_science/databases/mysql/mysql_tips_trics.1615137072.txt.gz
  • Last modified: 2023/12/01 12:07
  • (external edit)