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

I have. I placed software hooks into the SQLite memory heap manager and determined that SQLite allocates memory for most operations and does not give the memory back until it closes. I didn't look any further as we are out of time. Ray Kalyani Tummala <[EMAIL PROTECTED]> wrote: > Hi Joe,

Re: [sqlite] Can the memory usage of SQLite be adjusted?

[EMAIL PROTECTED] wrote: > <[EMAIL PROTECTED]> wrote: > > [EMAIL PROTECTED] wrote: > > > <[EMAIL PROTECTED]> wrote: > > > > I completed my analysis of the SQLite database memory usage and I was > > > > surprised to find that SQLite consumes so much memory. I ran my test > > > > case

Re: [sqlite] Can the memory usage of SQLite be adjusted?

[EMAIL PROTECTED] wrote: > <[EMAIL PROTECTED]> wrote: > > I completed my analysis of the SQLite database memory usage and I was > > surprised to find that SQLite consumes so much memory. I ran my test > > case (creates 31 tables) and found that SQLite consumed 545,231 bytes of > >

[sqlite] How is the windows binary built?

I'm using cygwin under windows XP. gcc version 3.4.4 I unzipped the sqlite-3.3.16.tar.gz to the directory sqlite-3.3.16. Executed the following: cd sqlite-3.3.16 mkdir build cd build ./configure make The resulting sqlite3.exe is 4 times bigger than the windows release in sqlite-3.3.16.zip.

[sqlite] SQLite and memory usage

I performed a simple experiment where i placed printf statements in the routines sqlite3FreeX and sqlite3MallocRaw. They seem to be the two lowest level routines in SQLite that allocate and deallocate memory. I redirected the output to a text file and imported it into Excel (this may have been

Re: [sqlite] Re: SQLite and nested transactions

Gerry, I took a look at this and I don't see how it works. I believe I would have to do the following: Make TEMP copies of all of the tables that are being modified. Upon COMMIT: Delete the old tables Rename the temp tables to the old tables COMMIT I don't see an easy way to do

Re: [sqlite] Re: SQLite and nested transactions

Thanks. I'll look into this path and see if it fits. Anybody here live in the Irvine, Ca area. After the discussions on this subject I have come to the conclusion that we need somebody to implement our embedded database. Ray Gerry Snyder <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED]

Re: [sqlite] Re: SQLite and nested transactions

I forgot to mention that the stream data contains a BEGIN TRANSACTION and END TRANSACTION marker. Ray [EMAIL PROTECTED] wrote: > In my case, I am a slave device that must accept a stream of commands from an > external device. I'm not sure if I can make intelligent decisions about >

Re: [sqlite] Re: SQLite and nested transactions

In my case, I am a slave device that must accept a stream of commands from an external device. I'm not sure if I can make intelligent decisions about choosing what I commit to the database. Ray Darren Duncan <[EMAIL PROTECTED]> wrote: > At 12:49 PM -0600 4/11/07, Dennis Cote wrote: >

[sqlite] Re: SQLite and nested transactions

It appears that my requirements are to be able to do the following: BEGIN parent; insert into t values ('a'); BEGIN child; insert into t values ('b'); insert into t values ('c'); ROLLBACK child; // child aborts insert into t values ('d'); COMMIT parent; As a result

Re: [sqlite] SQLite and nested transactions

So. If i read this code right. * The transaction_level keeps track of how many nested transactions have occurred. * Only the parent transaction allows the commit. In this case, only a single journal is required (the parent journal). Thanks, Ray Dennis Cote <[EMAIL PROTECTED]> wrote: >

Re: [sqlite] SQLite and nested transactions

Darren Duncan <[EMAIL PROTECTED]> wrote: > At 4:38 PM -0700 4/5/07, Darren Duncan wrote: > >To get this to work would basically involve having additional > >journal files, with the original one being for the parent-most > >transaction, and with an additional one for each transaction

[sqlite] SQLite and nested transactions

I have just read the omitted features section and noticed that SQLite doesn't support nested transactions. What effort is required to add this feature? What would be the next best DB that does support this feature? Ray

Re: [sqlite] Using the Sqlite Btree Backend directly

John Stanton <[EMAIL PROTECTED]> wrote: > Rollback is a problem with simpler software. > > You are basically specifying Sqlite in your requirements, and it does > all that wiith a small footprint based on the capability. > > You might contact Dr Hipp and enquire about a commercial

Re: [sqlite] Using the Sqlite Btree Backend directly

[EMAIL PROTECTED] wrote: > <[EMAIL PROTECTED]> wrote: > > > > > > > > I'm looking at using Sqlite as a storage backend for a program. > > > > Using SQL is a little bit overkill > > > > > > why bother with SQLite then? Use the right tool for the job > > > -- use BerkeleyDB. > > > > >

Re: [sqlite] Using the Sqlite Btree Backend directly

P Kishor <[EMAIL PROTECTED]> wrote: > On 3/29/07, Ludvig Strigeus <[EMAIL PROTECTED]> wrote: > > Hi, > > > > I'm looking at using Sqlite as a storage backend for a program. Using SQL is > > a little bit overkill and much more than we need. How complicated would it > > be to interface to the

Re: [sqlite] How does SQLite store data?

Dennis Cote <[EMAIL PROTECTED]> wrote: > John Stanton wrote: > > It does not have fixed length columns except for the ones which hold > > integer and real numbers and boolean values. > > > Actually, integers are stored in a variable length format as well. It > takes less space to store

[sqlite] How does SQLite store data?

I created several tables that specified explicitly the size of each column. I put some bogus numbers and text into it but I didn't put numbers in it that would completely fill the column data. I was surprised to find that the resulting database file was smaller than I had expected. This

[sqlite] Why does this script fail?

The Windows XP console command: sqlite3 baseSP.db < baseSP.sql Error message: SQL error near line 30: near ")": syntax error - To unsubscribe, send email to [EMAIL PROTECTED]