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,
[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
[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
> > malloce
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
malloced memory before it started giving it back.
I tried setting the pragma cach
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.
Ca
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 t
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 th
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] wrote
Here is an excerpt from my requirements doc:
Transactions
In addition to method calls, a session may include nested transactions. The
maximum number of transactions that can be nested is TBD. There are tokens in
the session stream that are transaction start and end tokens. The host is free
to s
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
> choosi
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:
> >[EMA
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 of
I'm still learning how databases and transactions work so bear with me.
How does error handling work?
If I have 5 nested transactions and the 5th transaction fails is this
transaction failure supposed to be communicated to the parent or does the
fourth transaction try to do error recovery?
Ray
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:
> D
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 level,
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
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 version
[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.
> > >
> >
>
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
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 sma
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 im
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]
--
22 matches
Mail list logo