通过python脚本执行的插入速度很慢，即使只有400行

import sqlite3

# 假设我们有一个包含400行数据的列表
data_to_insert = [
    (1, 'Alice'),
    (2, 'Bob'),
    # ... 其他数据
]

conn = sqlite3.connect('example.db')
cursor = conn.cursor()

# 创建表
cursor.execute('''CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY, name TEXT)''')

# 批量插入数据
cursor.executemany('INSERT INTO users (id, name) VALUES (?, ?)', data_to_insert)

# 提交事务
conn.commit()

# 关闭连接
conn.close()

import sqlite3

data_to_insert = [
    (1, 'Alice'),
    (2, 'Bob'),
    # ... 其他数据
]

conn = sqlite3.connect('example.db')
cursor = conn.cursor()

cursor.execute('''CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY, name TEXT)''')

# 开启事务
conn.execute('BEGIN TRANSACTION')

try:
    cursor.executemany('INSERT INTO users (id, name) VALUES (?, ?)', data_to_insert)
    conn.commit()
except Exception as e:
    print(f"Error: {e}")
    conn.rollback()

conn.close()

import sqlite3

data_to_insert = [
    (1, 'Alice'),
    (2, 'Bob'),
    # ... 其他数据
]

conn = sqlite3.connect('example.db')
cursor = conn.cursor()

cursor.execute('''CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY, name TEXT)''')

# 禁用索引
cursor.execute('DROP INDEX IF EXISTS idx_users_name')
cursor.execute('CREATE INDEX idx_users_name ON users(name)')

conn.execute('BEGIN TRANSACTION')
try:
    cursor.executemany('INSERT INTO users (id, name) VALUES (?, ?)', data_to_insert)
    conn.commit()
except Exception as e:
    print(f"Error: {e}")
    conn.rollback()

# 重新启用索引
cursor.execute('CREATE INDEX idx_users_name ON users(name)')

conn.close()