General information
Category:
Coding, syntax & commands
Title:
Is there a better way to replicate between db's than this?
I have users with a local copy of a database on their laptop machines. When they want to copy new/changed records to the master database (Network connection), they select a checkbox when viewing those records. The next time they are connected to the master database, they run a replication function which looks like this:
scan for a record with replication = .t.
search the master database for a matching record
IF the record does not already exist in the master
Append from the local database
ELSE
SCATTER the local record
GATHER to the master record
ENDIF
endscan
While this does work, it seems pretty slow. Is there a better way to do such a thing?
Thanks,
Pat
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only