On Wed, Feb 16, 2011 at 6:13 AM, <sasikuma...@tcs.com> wrote: > 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 >
I have no idea what a Motorola MC55 is, but either it is a very slow device or else you are doing something wrong. Some things to try: (1) Increase the number of inserts within a single transaction to 1000. Does that make it 100 times faster? (It should.) (2) Set PRAGMA journal_mode=WAL; (3) Populate your database on a workstation then copy it over to the device. > > 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 > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
