Welcome!

Welcome to the official BlackBerry Support Community Forums.

This is your resource to discuss support topics with your peers, and learn from each other.

inside custom component

Java Development

Reply
Developer
Posts: 49
Registered: ‎05-20-2009
My Device: Not Specified
Accepted Solution

How to use Pragma Statements in BlackBerry 5.0

Hi all,

 

   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?.

 

 

Thanks,

Abees

BlackBerry Development Advisor
Posts: 15,727
Registered: ‎07-09-2008
My Device: BlackBerry PRIV
My Carrier: Bell

Re: How to use Pragma Statements in BlackBerry 5.0

SQLite pragma statements are not supported on BlackBerry Smartphones.

Mark Sohm
BlackBerry Development Advisor

Please refrain from posting new questions in solved threads.
Problem solved? Click the Accept As Solution button.
Found a bug? Report it using Issue Tracker
Highlighted
Developer
Posts: 49
Registered: ‎05-20-2009
My Device: Not Specified

Re: How to use Pragma Statements in BlackBerry 5.0

[ Edited ]

Hi,

 

   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.

 

 

Thanks

Abees