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...
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...