[sqlite] Single INSERT is very slow

Hello sqlite users, Hello Dr. Hipp, while using sqlite v3.0.6, I've discovered that doing a single INSERT or UPDATE on a table which has only one field is very slow: CREATE TABLE Test (Field1 VARCHAR(10)); INSERT INTO Test VALUES ('123'); the INSERT statement above takes approx. 150 milliseconds

Re: [sqlite] Single INSERT is very slow

For a more useful test, please make a second table with 2 fields, like Test but with a second VARCHAR(10) column. Then compare the speed of inserting into that table vs inserting into your first one. After all, if the problem is specific to single-column tables, then we should get rid of all