如何在OpenCv中更有效地使用SQL查询，而不必在每个帧中插入数据。

import cv2
import mysql.connector

# 建立与数据库的连接
connection = mysql.connector.connect(
    host="localhost",
    user="username",
    password="password",
    database="database_name"
)

# 创建数据库游标
cursor = connection.cursor()

# 打开视频文件
cap = cv2.VideoCapture('video.mp4')

while cap.isOpened():
    ret, frame = cap.read()

    if not ret:
        break

    # 在每个帧中执行SQL查询
    query = "SELECT * FROM table_name WHERE frame_id = %s"
    cursor.execute(query, (frame_id,))

    # 处理查询结果
    result = cursor.fetchall()
    for row in result:
        # 处理每一行数据

    # 显示帧
    cv2.imshow('Frame', frame)

    if cv2.waitKey(1) & 0xFF == ord('q'):
        break

# 关闭数据库连接和视频流
cursor.close()
connection.close()
cap.release()
cv2.destroyAllWindows()