my_huge_dictionary = {'A': 1, 'B': 2, 'C': 3, 'D': 4}
conn = sqlite3.connect('my.db')
c = conn.cursor()
c.execute(
    """
create table dictionary (
k char[10] NOT NULL,
v integer NOT NULL,
PRIMARY KEY (k))
"""
    )
for k, v in list(my_huge_dictionary.items()):
    pass
Загрузка огромного словаря Python Pickle