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); sqlite3_step(sq3_stmt); sqlite3_finalize(sq3_stmt); 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 can. Any hints are welcome. Thanks, Levente _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
