Android Question SQL Speed-Question

[Andreas_D99]

Wich Way is faster (better) ?
Truncate Table from the local SQLite-DB and fill it new with INSERT INTO from Remote mysql-DB
or
search local SQLite-Table Row by Row if Timestamp-Field has changed an update with UPDATE-Statement (only the changed Fields...) ?

Best Regards...

 

[sorex]

if it is only one way consulting I'd just download the data if possible. if not stick with the old local dataset.