Hi joe,
Thanks for your response.
In order to reduce the footprint size, I have bypassed parser completely
and using byte codes directly as my schema and queries are almost
compile time fixed. Hence I am not using sqlite3_prepare().
The following is the schema and inserts I am using.
CREATE TABLE OBJECT(
PUOI INTEGER PRIMARY KEY,
Storage_Id INTEGER,
Object_Format INTEGER,
Protection_Status INTEGER,
Object_Size INTEGER,
Parent_Object INTEGER,
Non_Consumable INTEGER,
Object_file_name TEXT,
Name TEXT,
File_Path TEXT
);
CREATE TABLE AUDIO(
PUOI INTEGER PRIMARY KEY,
Use_Count INTEGER,
Audio_Bit_Rate INTEGER,
Sample_Rate INTEGER,
Audio_Codec_Type INTEGER,
Number_of_Channels INTEGER,
Track INTEGER,
Artist TEXT,
Title TEXT,
Genre TEXT,
Album_Name TEXT,
File_Path TEXT
);
INSERT INTO OBJECT VALUES (
7, 65537, 12297, 0,
475805, 6, 0,
'ANJANEYASTOTRAM.mp3', NULL,
'C:\\MTPSim\\Store0\\Music\\Artist\\Album\\ANJANEYASTOTRAM.mp3'
);
INSERT INTO AUDIO VALUES (
7, 6, 144100, 0,
0, 0, 6,
NULL, NULL, 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\\Album\\BHADRAM.mp3'
);
INSERT INTO AUDIO VALUES (
8, 6, 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 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, 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?
________________________________________________________________________
____________Choose the right car based on your needs. Check out Yahoo!
Autos new Car Finder tool.
http://autos.yahoo.com/carfinder/
------------------------------------------------------------------------
-----
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]
-----------------------------------------------------------------------------
