self.connector = sqlite3.connect(self.dbFile)
self.cursor = self.connector.cursor()

并且close()停止使用它.

self.cursor.close()

它们的价格(处理时间)有多贵？它是如此昂贵以至于只有绝对必要才能使用吗？或者,在功能中多次使用它是否可以？

添加

我使用以下简单代码进行了测试. proc1()使用在运行查询时始终打开和关闭的代码,proc2()只运行一次.

from sqlite import *
import timeit
import math

def proc1():
    db = sqliteDB("./example.db",False)
    db.getOpenRunClose("SELECT * from Benchmark")
    db.getOpenRunClose("SELECT * from Benchmark")
    db.getOpenRunClose("SELECT * from Benchmark")
    db.getOpenRunClose("SELECT * from Benchmark")
    db.getOpenRunClose("SELECT * from Benchmark")
    db.getOpenRunClose("SELECT * from Benchmark")

def proc2():
    db = sqliteDB("./example.db")
    res = db.runsqlToGetResult("SELECT * from Benchmark")
    res = db.runsqlToGetResult("SELECT * from Benchmark")
    res = db.runsqlToGetResult("SELECT * from Benchmark")
    res = db.runsqlToGetResult("SELECT * from Benchmark")
    res = db.runsqlToGetResult("SELECT * from Benchmark")
    res = db.runsqlToGetResult("SELECT * from Benchmark")
    db.close()

if __name__ == '__main__':
    t = timeit.Timer(proc1)
    count = 5000
    print t.timeit(count) / count

    t = timeit.Timer(proc2)
    count = 5000
    print t.timeit(count) / count

结果如下.

0.00157478599548
0.000539195966721