05-10-2010 08:44 AM
How can we use SQLite Pragma Statements in BlackBerry?.Please help me with an example .When we execute this pragma statments?.while creating db or while opening db?.
Solved! Go to Solution.
05-13-2010 03:30 PM
SQLite pragma statements are not supported on BlackBerry Smartphones.
05-14-2010 03:15 AM - edited 05-14-2010 05:03 AM
Thank you MSohm for the reply.
I have one issue.My application having a sync process.Which downloads records from server and inserting into local database.I am using SQLite as DB.While inserting records it takes much time .So that Sync process takes long time to complete.It was my plan that to use Pragma Statements,"Synchronous = off " and "cache_size = 2000 ", to speed up the insert process.As of now BlackBerry doesn't support Pragma Statements, what is the solution to speed the the DB Operations while syncing.I m using only single transaction for the sync process that means there is no seperate Transactions for insert/delete/update process of each table.I am Stuck with this Performance issue.