SQLite Forum

Memory spike with zeroblob
Login
Hello,

I have this sample python code that I run under x64 3.8.6 on Windows

import sqlite3
file = "BLABLABLABLBLA_sql.bak"
db = sqlite3.connect('generic.bckp')
cursor = db.cursor()
cursor.execute('CREATE TABLE t (id INTEGER PRIMARY KEY, b BLOB, p BLOB)')
cursor.execute('INSERT INTO t VALUES(?, zeroblob(?), ?)', [1, 100256716, file.encode()])


Problem is the memory profiler says it allocates about 200 Mb of memory

If I remove either the zeroblob or the binary encoded file name - all is well

Momchil Bozhinov
(posting anonymously due to being lazy)