一度読み込んだSQLファイルをメモ化を使ってキャッシング

pysqlite3.py

import sqlite3

queries = {}
def test1():
    sql = ""
    with open("./test.sql") as f:
        sql = f.read()
    with sqlite3.connect("./test.db") as db:
        cursor = db.cursor()
        cursor.execute(sql)
        db.commit()

def test2():
    sql = ""
    if "test" in queries:
        sql = queries["test"]
    else:
        with open("./test.sql") as f:
            sql = f.read()
            queries["test"] = sql
    with sqlite3.connect("./test.db") as db:
        cursor = db.cursor()
        cursor.execute(sql)
        db.commit()

table.sql

create table persons (
   name text    not null
  ,age  integer not null
);

test.sql

insert into persons (name, age) values ('test', 20);

test1.py

# coding: -*- utf-8 -*-

import time
import pysqlite3

if __name__ == "__main__":
  start = time.time()
  for i in range(0, 10000):
    pysqlite3.test1()
  elapsed_time = time.time() - start
  print("処理時間: {0}".format(elapsed_time))

test2.py

# coding: -*- utf-8 -*-

import time
import pysqlite3

if __name__ == "__main__":
  start = time.time()
  for i in range(0, 10000):
    pysqlite3.test2()
  elapsed_time = time.time() - start
  print("処理時間: {0}".format(elapsed_time))