Re: [sqlite] SQLite minimum RAM requirements?

2006-05-28 Thread [EMAIL PROTECTED]
Hi,
The product GoDB uses SqLite and works on a lot of PDA and phoes. And many of 
these pdas are also mp3 players
Bill
 


Re: [sqlite] SQLite minimum RAM requirements?

2006-05-28 Thread drh
Andreas Schwarz <[EMAIL PROTECTED]> wrote:
> Hi,
> 
> I would like to use SQLite in an embedded device (MP3 player), but I
> didn't find any information on minimum RAM requirements. Can anyone give
> me a rough estimate of how much RAM I will need? 1k/10k/100k/1M?
> 

You can configure it in various ways.

Embedded device manufactures tell me that they usually
get away with a 4K or 8K stack and 50-60K of heap space.

Of course, the more memory you give it, the faster it tends
to go.

If you can share the heap space with other threads of your
product (so that SQLite can use more heap when it needs to
but let other processes use that heap when SQLite doesn't 
need it) then so much the better.  Note that version 3.3.x
of SQLite has some APIs specifically designed to help support
this kind of thing.  See:

 sqlite3_soft_heap_limit
 sqlite3_release_memory

--
D. Richard Hipp   <[EMAIL PROTECTED]>



[sqlite] SQLite minimum RAM requirements?

2006-05-28 Thread Andreas Schwarz
Hi,

I would like to use SQLite in an embedded device (MP3 player), but I
didn't find any information on minimum RAM requirements. Can anyone give
me a rough estimate of how much RAM I will need? 1k/10k/100k/1M?

Andreas