Dear All, I am unsing SQLite on NOR Flash with Sqlite version 3.8.5 with default setting i.e. sector and page size. Writing to NOR Flash taken around 10 seconds ( SQLite file size of 400KB, which is somehow not acceptable). Upon inserting additional debug prints, I found that since I use the following API
sqlite3_backup_init() <http://www.sqlite.org/c3ref/backup_finish.html#sqlite3backupinit> sqlite3_backup_step() <http://www.sqlite.org/c3ref/backup_finish.html#sqlite3backupstep> sqlite3_backup_finish() <http://www.sqlite.org/c3ref/backup_finish.html#sqlite3backupfinish> SQLite writes data in very small chunks i.e. 1, 4, bytes which causes the poor performance while writing to Flash Please suggest if there are some experiences to fine tune the writes to NOR Flash. Kind Regards Vivek _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
