Thanks Joe, 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: sqlite-users@sqlite.org 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] ------------------------------------------------------------------------ ----- ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify [EMAIL PROTECTED] ********************************************************************** ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
