I'm implementing an application that is on a flash filesystem (JFFS).
The flash is connected to the CPU with SPI.
I experience about 1s INSERT time. My DB isn't big, just about 200k. I
implement a fifo like operation, so i have a fixed length row count. I
DELETE old data from time to time.
I call these function at each INSERT:
sqlite3_prepare_v2(sq3, query, -1, &sq3_stmt, NULL);
query holds the INSERT SQL.
The question is what can I do to speed up the INSERT proces? The database is
also opened by other processes, so I want to lock the table as short time as I
Any hints are welcome.
sqlite-users mailing list