Re: [sqlite] help,low RAM problem

2009-06-10 Thread pierr
You have to configure the page size and cache size (number of pages) to fit your 30K RAM. To be specific: page size * cache size < 30K. 徐中华 wrote: > > > > > hi, > I have a project based on an embedded platform. > the platform just has 30K RAM and a large NAND Flash, > so I want to use

Re: [sqlite] help,low RAM problem

2009-06-02 Thread Christopher Taylor
I have used sqlite on a similar platform. I use the GHS Integrity operating system. With a few tweaks I was able to get it to run well. The flash will keep things on the slower side, but I see my inserts (with idexes) taking a little as 0.05 seconds. Queries of 250 out of 10K sorted taking

Re: [sqlite] help,low RAM problem

2009-05-13 Thread Christopher Taylor
In my app, I had to adjust the default cache size. This was 2000 pages and caused my app to run out of memory. I dropped it down to 200. You may want to drop it even further. Chris ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] help,low RAM problem

2009-05-12 Thread 徐中华
hi, I have a project based on an embedded platform. the platform just has 30K RAM and a large NAND Flash, so I want to use SQLite on this platform. Can SQLite 3.6 be used on this platform . And if it 's possible, how can I configure the SQlite ? Thanks.