Most probably it will be a memory leak in your program. We must release
the dynamically allocated memory ourselves. So check whether you are
forgetting to do that. Most probably that leak will be happening inside
some loops or repeatedly calling functions.
On Fri, 2006-10-27 at 17:00 +0100, Ben
At 18:00 27/10/2006, you wrote:
Dear Sqlite,
I very much enjoy using Sqlite, it is extremely useful.
I have a memory usage query.
I am linking to libsqlite3.so.0.8.6. After calling
sqlite3_open(...) I find my programs data memory jumps by 16392 Kb.
This seems a lot. The database I am
Why don't you design the table with a unique row ID, stored in an
integer field, then fetch a list of those ID numbers?
For 5000 rows, assuming you store them in you application as 4 byte
longs, that's about 19 k of memory.
Counting that result as you receive it isn't that difficult. If it
On 10/27/06, Ben Clewett <[EMAIL PROTECTED]> wrote:
I am linking to libsqlite3.so.0.8.6. After calling sqlite3_open(...) I
find my programs data memory jumps by 16392 Kb.
This seems a lot. The database I am opening is only 26K in size.
There are many different ways of memory "jump" (like
Dear Sqlite,
I very much enjoy using Sqlite, it is extremely useful.
I have a memory usage query.
I am linking to libsqlite3.so.0.8.6. After calling sqlite3_open(...) I
find my programs data memory jumps by 16392 Kb.
This seems a lot. The database I am opening is only 26K in size.
I have
Hi DRH,
A mailing list post by you outlines a similar problem that I am seeing:
http://www.mail-archive.com/sqlite-users@sqlite.org/msg15913.html
Have you given any thought to this index page locality matter?
Perhaps something like:
PRAGMA reserve_pages_for_indexes = 5
Whereby a
An SQLite NOT NULL issue related to primary keys that may be of interest:
http://www.mail-archive.com/sqlite-users@sqlite.org/msg17947.html
- Original Message
From: Scott Hess <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Friday, October 27, 2006 3:00:46 AM
Subject: [sqlite]
Peter De Rijk <[EMAIL PROTECTED]> wrote:
> I have run into a serious performance problem with tables with many rows.
> The problem only occurs on tables with an index
> The time needed for an insert into a table with an index is dependend on the
> number of rows. I have not formally checked, but
Peter De Rijk wrote:
I have run into a serious performance problem with tables with many rows.
The problem only occurs on tables with an index
The time needed for an insert into a table with an index is dependend on the
number of rows. I have not formally checked, but from my tests it looks
I have run into a serious performance problem with tables with many rows.
The problem only occurs on tables with an index
The time needed for an insert into a table with an index is dependend on the
number of rows. I have not formally checked, but from my tests it looks like
an exponential
"Scott Hess" <[EMAIL PROTECTED]> wrote:
> In some database systems, it can be beneficial to use "NOT NULL" as
> much as possible when defining tables. It usually allows for a
> slightly tighter storage encoding, and also allows some optimizations
> to occur.
>
> AFAICT, in sqlite it only seems
T wrote:
I can use a slightly modified CSV parsing handler, by just using this
as the row separator (instead of just plain linefeed):
");INSERT INTO VALUES("
Neat :)
Martin
-
To unsubscribe, send email to [EMAIL
Hello,
I just try building the standard SQLite 3.3.8 shell using a really
simple Xcode projet just having the files "shell.c", "sqlite3.h" and
"libsqlite3.a".
The last two were obtained builing the sqlite sources as told by the
readme:
tar xf sqlite-3.3.8.tar
mkdir
ok..Thank you.Let me try that and let you know.
- Original Message -
From: "Lloyd" <[EMAIL PROTECTED]>
To:
Sent: Friday, October 27, 2006 12:36 PM
Subject: Re: [sqlite] reg:SqliteDB file
> Whether your question mean to open database file which is in some other
In some database systems, it can be beneficial to use "NOT NULL" as
much as possible when defining tables. It usually allows for a
slightly tighter storage encoding, and also allows some optimizations
to occur.
AFAICT, in sqlite it only seems important for constraining the data
appropriately.
Whether your question mean to open database file which is in some other
location?
If yes,
we will be using the
int sqlite3_open(const char *filename,sqlite3 **ppDb);
call to open the database. In that we will have to mention the file
name. There instead of using the file name simply, give
Hi,
Is it possible to refer db file from other than the Current project
location.If Yes,How can we refer(tell) the location of the DB file to the
project.Please help me.
Thank you all,
- Sandhya
17 matches
Mail list logo