02-22-2012 10:51 PM
When I do this on a physical device ( 0330 Curve OS6) the application locks up on startup. I think this is because the database is not being built succesfully. Has anyone encountered a problem like this?
02-29-2012 09:12 PM
Gave up on getting the full database to load for the 9330. Created a smaller database and changed the app so that it ran more limited queries. Plan to deploy this modified app to ow powered devices and keep the full database and original app for higher powered devices that don't seem to have a problem (1Ghz +).
03-27-2012 01:53 PM
Just curious - do you know the size limit for SQLite when using Web SQL? I also have strange problems with Curve 9330 that I don't have when using emulators. I noticed that when using smaller chunks of INSERT helps, but it is still erratic.
03-27-2012 02:09 PM
I don't believe there is a real limit to the size of sqlite tables based on the documentation I've seen.
"Maximum Number Of Rows In A Table
The theoretical maximum number of rows in a table is 264 (18446744073709551616 or about 1.8e+19). This limit is unreachable since the maximum database size of 14 terabytes will be reached first. A 14 terabytes database can hold no more than approximately 1e+13 rows, and then only if there are no indices and if each row contains very little data."
I think the limitations have more to do with the hardware of the device you are trying to use.
The largest tables I was trying to load on my 9330 curve were around 20K rows.
On Blackberries with more robust hardware than this curve model, I haven't had a problem.
Certainly not on any of the more recent OS7 devices.
03-27-2012 02:22 PM
I am aware of the SQLite technical details. However, in Web environment sometimes there limits set by browser manufecturers (iOS has 50 MB size limit for all database for a single origin). I could not find any info for the BB, though.
04-09-2012 08:47 AM
The BlackBerry Web engine should be enforcing a 5Mb limit per domain for WebDB meaning you could get 60+ Mb of data stored for your application if it is leveraging multiple domains. For WebWorks applications, the 5Mb limit should be per application. As it was mentioned earlier in this thread, this is part of the Web standard.
If you are seeing otherwise it could be a non-compliance bug?