Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is there a better way to replicate between db's than this?
Message
From
07/11/2001 11:40:46
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Is there a better way to replicate between db's than this?
Miscellaneous
Thread ID:
00578549
Message ID:
00578549
Views:
67
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
Map
View

Click here to load this message in the networking platform