Syncing external JSON source to local storage

Syncing external JSON source to local storage

Hi guys,

I'm developing an application for representatives of our company. They'll use it when they visit customers and write orders for them.

Currently a single representative has a minimum of 250 customers, all of which need to be synced to the local device because not all customers are within reach of an internet connection whether it's Wifi or 3G.

Besides the customers there are also the products that needs to be synced. Currently our catalog of around 1800 different SKU's is divided in 9 groups, which in turn are divided in products. These products have different models which can have different colors. Do you still follow me?

Well to clarify. A group has several products. A product has several models and models have several colors.

As soon as the app is started for the first time I check if the local storage is filled with products and customers. If it is, I don't need to sync, though this can be manually triggered. If it isn't I trigger the sync. The sync is a different store connected to an external JSON source using Basic auth. I then grab the records and put it in a MixedCollection to be handled by an DelayedTask due to the low time out treshold on the iPad.

Though this works fine it takes a very long time before all products and customers are synced. Now I could just say to the representatives that they need to sync in the evenings when they're not using the iPad, but I rather just speeds things up. Do you guys have any suggestions?