[sqlite] Performance Problem

[sasikumar . u]

Hi,

I'm using Motorola MC55 device, with 2GB external memory card.

For the SQlite Db I have used the following Pragma values 

PRAGMA cache_size = 16000
PRAGMA  temp_store = 2
PRAGMA  synchronous = OFF
PRAGMA  locking_mode = EXCLUSIVE

for some performance improvement

For insertion of records I use

sqlite3_prepare

then binding the values using

sqlite3_bind_int64

and finally executing using

sqlite3_step

We use to insert a set of 10 records every time, so I use "BEGIN" and 
"COMMIT" transaction .

Despite these the insertion is slow, like it takes around 700 milliseconds 
to insert one record, is there anyother way to improve the performance.
Kindly help in this regard

Regards,
Sasikumar U
=-=-=
Notice: The information contained in this e-mail
message and/or attachments to it may contain 
confidential or privileged information. If you are 
not the intended recipient, any dissemination, use, 
review, distribution, printing or copying of the 
information contained in this e-mail message 
and/or attachments to it are strictly prohibited. If 
you have received this communication in error, 
please notify us by reply e-mail or telephone and 
immediately and permanently delete the message 
and any attachments. Thank you


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] In Memory Usage

[sasikumar . u]

Hi All,

I'm using SQLite DB version 3.6.12. I recently read about the feature of 
In-Memory Database and tried to implement it. I was able to create a new 
DB connection in memory, able to create a table and insert some set of 
records into the memory DB. 

How should I now transfer those records into the real table in the real 
DB, someone kindly assist and guide me.


Regards,
Sasikumar U
=-=-=
Notice: The information contained in this e-mail
message and/or attachments to it may contain 
confidential or privileged information. If you are 
not the intended recipient, any dissemination, use, 
review, distribution, printing or copying of the 
information contained in this e-mail message 
and/or attachments to it are strictly prohibited. If 
you have received this communication in error, 
please notify us by reply e-mail or telephone and 
immediately and permanently delete the message 
and any attachments. Thank you


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users