Databases
StackOverflow2013
Postsdbo
POOptimal way to save/parse XML on iPhone
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POOptimal way to save/parse XML on iPhone
    primarykey
    data
    text
    <p>This is my first question so I will do my best to conform to the question guidelines. </p> <p>I am developing an iPhone app that parses and XML feed to be displayed in a table. Parsing is not a problem but I am not sure of the best way to optimize loading times after initial run of the app. </p> <p>Here is the different approaches that I am considering:</p> <ol> <li><p>Parse the XML feed each time the application is loaded. <em>Easy way but possibly longer loading time each run of the app.</em></p></li> <li><p>Grab the feed and store it locally (as .xml) then parse locally. Then, each time the app is opened, make an http call to see if the feed has been changed. If not, parse locally. If so, download the new feed and parse locally. <em>The initial loading time will be longer but could be cut down on later runs (if the feed as not been updated). This option will be beneficial if the user has a bad signal but needs to see the data.</em> </p></li> <li><p>Parse the feed and store it into a local sqlite db. Then, each time the app is opened, make an http call the see if the feed has been changed. If so, detect which objects have been added/removed and alter local db accordingly. If not, load data from local db. <em>This might be the best option but I am not sure how long finding the changes will take.</em></p></li> </ol> <p>My feed is only about 100 or so items, each with roughly 20 fields. </p> <p>Initial parsing time:</p> <ul> <li>Roughly 4-5sec with full bars. </li> <li>Roughly 5-7sec with 3 bars.</li> </ul> <p>Any insight as to which option would work best would be very much appreciated.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USrandom
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POOptimal way to save/parse XML on iPhone
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POOptimal way to save/parse XML on iPhone
      1. This table or related slice is empty.
      1. VTUpMod
    1. COIf you store in the database then you might end up with the stale copy of the feed. Just parse the feed every time since I am assuming that the feed will be changing quite frequently.
      singulars
      1. POOptimal way to save/parse XML on iPhone
      1. USazamsharp
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload