search

ekelly / Husky-Hunters-Android

3 stars 0 forks source link

Database benefits #9

Closed fnimick closed 12 years ago

fnimick commented 12 years ago

Database benefits: having a row correspond to a clue would be much faster than instantiating 500+ clue objects, instantiate 1 clue object perhaps upon detail view.

Database has a timestamp for when it was last synced with server, each clue row has a timestamp for when it was last updated, when syncing only update those clues that were changed since that timestamp (send last updated timestamp to server with sync request)

ekelly commented 12 years ago

each row just needs an 'uploaded' boolean instead of a timestamp

fnimick commented 12 years ago

true. we should also include for a sync that downloads only, ex. we probably only want to upload photos once we are back at base with wifi access

ekelly commented 12 years ago

We should move the 'photo_path' to a new table, with 2 columns - path and clueid. That way clues can have multiple photos