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)) != SQLITE_DONE)
{
Tr_Err("SwapDB sqlite3_backup_step sqlErrno %d", sqlErrno);
result = false;
}
if ((sqlErrno = sqlite3_backup_finish(pBackup)) != SQLITE_OK)
{
Tr_Err("SwapDB sqlite3_backup_finish sqlErrno %d", sqlErrno);
result = false;
}
}
else
{
Tr_Err("SwapDB could not be init");
result = false;
}
Br
Vivek
On Wed, Jun 25, 2014 at 10:14 PM, Vivek Ranjan <[email protected]>
wrote:
> 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
>
>
--
Vivek(Mobile) : +49 17655 040018
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
