如何将大尺寸的json feed导出到MYSQL Table？

import json
import pymysql

# 读取JSON文件或从API获取JSON数据
with open('feed.json', 'r') as f:
    json_data = json.load(f)

# 建立与MySQL数据库的连接
connection = pymysql.connect(
    host='localhost',
    user='your_username',
    password='your_password',
    db='your_database'
)

# 创建游标对象
cursor = connection.cursor()

# 解析JSON feed并插入到MySQL Table
for item in json_data:
    # 将JSON对象的属性映射到表的列
    name = item['name']
    age = item['age']
    email = item['email']
    
    # 执行插入操作
    insert_query = "INSERT INTO your_table (name, age, email) VALUES (%s, %s, %s)"
    cursor.execute(insert_query, (name, age, email))

# 提交事务
connection.commit()

# 关闭连接
cursor.close()
connection.close()