Re: [sqlite] How to restrict the peak heap usage during multiple inserts and updates?

modifications? Regards Kalyani -Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 29, 2007 9:25 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] How to restrict the peak heap usage during multiple inserts and updates? In your case we would not use

RE: [sqlite] How to restrict the peak heap usage during multiple inserts and updates?

ation. > > Thank you > Kalyani > > -Original Message- > From: Joe Wilson [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 29, 2007 9:40 PM > To: sqlite-users@sqlite.org > Subject: RE: [sqlite] How to restrict the peak heap usage during > multiple

RE: [sqlite] How to restrict the peak heap usage during multiple inserts and updates?

It may not be possible to get peak heap usage down to 30K, but here's some random ideas: I imagine you've already tried defining SQLITE_OMIT_* for the features that you don't need. Verify that your embedded OS has a space-efficient malloc implementation. Try to find a realtime graphical heap a

RE: [sqlite] How to restrict the peak heap usage during multiple inserts and updates?

:[EMAIL PROTECTED] Sent: Tuesday, May 29, 2007 9:40 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] How to restrict the peak heap usage during multiple inserts and updates? The default is auto-commit, so unless you've opened an explicit transaction with BEGIN and do a number of inserts

RE: [sqlite] How to restrict the peak heap usage during multiple inserts and updates?

LL, NULL, NULL, >>'C:\\MTPSim\\Store0\\Music\\Artist\\Album\\ANJANEYASTOTRAM.mp3' >>); >> >>INSERT INTO OBJECT VALUES ( >> 8, 65537, 12297, 0, >> 387406, 6, 0, >> 'BHADRAM.mp3', NULL, >>'C:\\MTPSim\\Store0\\Music\\Artist\\A

RE: [sqlite] How to restrict the peak heap usage during multiple inserts and updates?

I think I know what's going on. When you insert new rows in the presence of indexes then sqlite must touch a lot of pages in each trascation to satisfy the rebuilding of the index(es). These pages are built up in the transaction log which is stored in temp_store, which happens to be memory in yo

RE: [sqlite] How to restrict the peak heap usage during multiple inserts and updates?

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: > > >

RE: [sqlite] How to restrict the peak heap usage during multiple inserts and updates?

2007 6:51 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] How to restrict the peak heap usage during multiple inserts and updates? Since you are only using part of Sqlite have you considered using a much smaller footprint storage system which only implements the functions you are using

Re: [sqlite] How to restrict the peak heap usage during multiple inserts and updates?

in advance Kalyani -Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 29, 2007 6:51 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] How to restrict the peak heap usage during multiple inserts and updates? Since you are only using part of

RE: [sqlite] How to restrict the peak heap usage during multiple inserts and updates?

-Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 29, 2007 6:51 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] How to restrict the peak heap usage during multiple inserts and updates? Since you are only using part of Sqlite have you considered

Re: [sqlite] How to restrict the peak heap usage during multiple inserts and updates?

144100, 0, 0, 0, 6, NULL, NULL, NULL, NULL, 'C:\\MTPSim\\Store0\\Music\\Artist\\Album\\BHADRAM.mp3' ); Warm regards Kalyani -Original Message- From: Joe Wilson [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 29, 2007 9:42 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] How

RE: [sqlite] How to restrict the peak heap usage during multiple inserts and updates?

: [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 querie

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

RE: [sqlite] How to restrict the peak heap usage during multiple inserts and updates?

son [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 29, 2007 9:42 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] How to restrict the peak heap usage during multiple inserts and updates? > I am working at porting sqlite ( ver 3.3.8 ) on an embedded device with > extremely low main memory

Re: [sqlite] How to restrict the peak heap usage during multiple inserts and updates?

> 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, t

[sqlite] How to restrict the peak heap usage during multiple inserts and updates?

Dear group, 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, t