I thought too to a cache-like issue, so I added the AUTOINCREMENT; I don't care about the fact it uses more CPU as it is used very very seldom.
BEGIN TRANSACTION;
DROP TABLE IF EXISTS recipe;
CREATE TABLE IF NOT EXISTS recipe (
ID INTEGER PRIMARY KEY AUTOINCREMENT,
rname VARCHAR ( 255 ),
heat_6_7 INTEGER,
heat_11_12 INTEGER,
temp INTEGER,
hyst INTEGER,
purge_delay INTEGER,
spray_time INTEGER,
idle_time INTEGER,
n_cycle INTEGER
);
COMMIT;
I think I thought to a solution: look my other 3D