On 6 Oct 2010, at 4:50pm, David Haymond wrote: > If I copy, I don't want to transfer EVERY record to the server each time I > sync, because that would be a waste of bandwidth. What is the best way to > copy only those records that have changed to the server?
Make a new column for each table, with a lastchanged timestamp. Put an index on that column. Either keep the column updated manually, or use a TRIGGER to do it automatically. Somewhere else, record the timestamp that the previous synchronisation was done. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users