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

Native Development

Reply
Developer
Brennan12325
Posts: 205
Registered: ‎05-15-2012
My Device: None

Re: What is the fastest data access type JsonDataAccess, SqlDataAccess, or XmlDataAccess

I ended up getting about 2.5x improvement simply from going from XmlDataAccess to SqlDataAccess, 15 seconds to 6 seconds. For a little extra context, my raw data in an SQLite database is 631kb. As XML it was ~3.5MB over a few different files.

 

I got additional speed improvements on the SQL load, bringing my load time to under 1 second, which I've deemed acceptable so I've quit working on speeding it up. (I think this improvement was making sure the database stayed open betwee queries, but I can't recall exactly).

 

Very interesting to hear qsqlquery with forwardonly=true is so much faster. It obviously makes sense, since that eliminates a ton of work on the DB end. It would be nice to see a few more options like this propogated to SqlDataAccess.

----------------------
Check out my app, Alien Flow for reddit

And of course, like my post if you found it helpful or informative!