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