在循环中创建新对象的效率

def generate_strings(n):
    for i in range(n):
        yield str(i)

strings = generate_strings(1000000)

def generate_list(n):
    return [i for i in range(n)]

list1 = generate_list(1000000)

import sqlite3

def generate_dict(n):
    conn = sqlite3.connect('my_database.db')
    c = conn.cursor()
    for i in range(n):
        c.execute("CREATE TABLE IF NOT EXISTS my_table (key INTEGER PRIMARY KEY, value INTEGER)")
        c.execute("INSERT INTO my_table (key, value) VALUES (?, ?)", (i, i*2))
    conn.commit()
    conn.close()

dict1 = generate_dict(1000000)