04-23-2014 04:54 PM
On 9900s/9930s over AT&T 4G or VZW 3G cellular w/BBOS 7.1 via BES: We have a native app which downloads about 50,000 rows from SQLserver into a SQLite db for use case where users are intermittently disconnected from wireless coverage (i.e. offline access). On device db = about 50 MB. Data goes from internal SQLserver -> internal Webservice -> JSON response -> BES --> native client app ->locally stored SQLite db in the database folder. User can then search the data locally. Periodically, the native code checks for server-side data updates and applies them. Client app calls the webservice, gets a row count, then requests 500 rows at a time, processes them/binds them to the db, then asks for the next 500 rows until all 50,000 rows are posted to the on-device SQLite db.
Is there a way to:
(a) release the memory/caches/etc. after each 500 record return from the webservice during processing
(b) improve the speed of putting the json formatted data into the websql store
Thanks in advance.
05-15-2014 11:46 AM
Hi Julie - sorry for the delayed response to your post.
b) Again, suggest using remote web inspector to evaluate performance and narrow down which functions / code snippets are slowing things down. If you are formatting & concatenating lots of strings, it may be the source of a bottleneck.
c) no this is not possible. You must create the schema and then fill it from within the le app.
Hope that helps.