--- Joe Wilson <[EMAIL PROTECTED]> wrote:
> > I am working at porting sqlite ( ver 3.3.8 ) on an embedded device with
> > extremely low main memory.
> >
> > I tried running select queries on the tables( with about 2k records each
> > having about 5 strings) and they do well within 20kB of runtime heap
> > usage.
> >
> > But, when I try new insertions, the heap usage grows tremendously (about
> > 70 kB at peak).
>
> Perhaps preparing the statements (sqlite3_prepare) might decrease RAM
> use somewhat.
>
> Can you post an example of your schema and these insert statements?
Is your temp_store in memory or flash ram or other?
Another thought... are you performing a COMMIT after each INSERT?
(or at least every X inserts, where X<100)?
It might help to reduce memory (at the cost of reduced speed).
____________________________________________________________________________________Get
the free Yahoo! toolbar and rest assured with the added security of spyware
protection.
http://new.toolbar.yahoo.com/toolbar/features/norton/index.php
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
