Re: [sqlite] speed, writing spends 30ms, reading spends 2ms, still slow

iubin liu Sent: 24 December 2009 02:35 To: sqlite-users@sqlite.org Subject: [sqlite] speed, writing spends 30ms, reading spends 2ms, still slow the process runs on a board with Atmel AT91SAM9260 (Clocks: CPU 198 MHz, ...), Memory: 16MB, yaffs on NAND 256MB. the time of writing one row is more than

Re: [sqlite] speed, writing spends 30ms, reading spends 2ms, still slow

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 liubin liu wrote: > Is it the ceiling of the SQLite3? If no, how to improve it? espically > improving the routine of writing. Your testing is not testing what you think it is. The test times include string formatting and query parsing in addition to

Re: [sqlite] speed, writing spends 30ms, reading spends 2ms, still slow

The environment is: Linux at91sam9260nand 2.6.25.10 SQLite 3.6.5 liubin liu wrote: > > the process runs on a board with Atmel AT91SAM9260 (Clocks: CPU 198 MHz, > ...), Memory: 16MB, yaffs on NAND 256MB. > > the time of writing one row is more than 20mS, and the time of reading one > row is mor

[sqlite] speed, writing spends 30ms, reading spends 2ms, still slow

the process runs on a board with Atmel AT91SAM9260 (Clocks: CPU 198 MHz, ...), Memory: 16MB, yaffs on NAND 256MB. the time of writing one row is more than 20mS, and the time of reading one row is more than 3mS. Is it the ceiling of the SQLite3? If no, how to improve it? espically improving the r