The default is auto-commit, so unless you've opened an explicit transaction with BEGIN and do a number of inserts, the COMMIT suggestion is not useful in reducing memory footprint.
(apologies in advance if this is obvious...) SDRAM is the normal volatile RAM, right? You know that temp_store is competing with sqlite for your RAM. If you point your temp_store to "disk" to use non-volatile storage (disk or flash) then you'd have more RAM available for sqlite. Or do you lack such non-volatile storage? You can run the tests on Windows by installing either Cygwin or MinGW/MSYS, installing Tcl 8.4, running configure, and then running "make test". You can change the generated Makefile to define various sqlite compile-time flags for memory debugging. Just scan the ifdef's in the source code for ideas what to enable. It's much easier to do this under Linux than under Windows, in my opinion. --- Kalyani Tummala <[EMAIL PROTECTED]> wrote: > My temp_store is SDRAM. Thanks for your suggestion of using COMMIT. I > have not used it. Any other pointers? > > Best Regards > Kalyani > > > -----Original Message----- > From: Joe Wilson [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 29, 2007 10:27 AM > To: [email protected] > Subject: Re: [sqlite] How to restrict the peak heap usage during > multiple inserts and updates? > > --- 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] -----------------------------------------------------------------------------
