Re: [sqlite] SQLite performance with NOR FLASH

[Vivek Ranjan]

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 
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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite performance with NOR FLASH

[Vivek Ranjan]

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()

sqlite3_backup_step()

sqlite3_backup_finish()


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