Monthly Archives: October 2009

in a client/server environment we sometimes have to bring down large data over the network, especially if we are displaying lookup tables. instead, if we could have a local copy of the same table and keep it in sync with the server table, we could decrease the network load.

server database setup

to do so, we first need to keep track of the changed records on the online database. this is done by having an update serial number for each record.

to track the deleted records, create a table called deleted with the fields tablename c(25), pk int, updatesr int.… Continue reading