Re: [sqlite] SQLite performance with NOR FLASH

On 26 Jun 2014, at 7:42am, Vivek Ranjan wrote: > Code looks like this: Thanks. I was wondering whether you called _step() with strange value but you're calling it with -1, which seems to be the best thing to do in your case. And I don't see anything else wrong with

Re: [sqlite] SQLite performance with NOR FLASH

Hello Simon, Code looks like this: /* move content */ sqlite3_backup *pBackup; pBackup = sqlite3_backup_init(destDBHandle, "main", sourceDBHandle, "main"); if(pBackup) { int sqlErrno; if ((sqlErrno = sqlite3_backup_step(pBackup, -1)) !=

Re: [sqlite] SQLite performance with NOR FLASH

On 25 Jun 2014, at 9:14pm, Vivek Ranjan wrote: > sqlite3_backup_init() > > sqlite3_backup_step() > > sqlite3_backup_finish() >

[sqlite] SQLite performance with NOR FLASH

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