Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Multi-Site Database Replication - SQL Server
Message
De
01/05/2017 14:06:44
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
01/05/2017 08:00:37
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows Server 2012 R2
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01650658
Message ID:
01650737
Vues:
30
>Walter already focused on them a bit. If you target replication in the long run it might be beneficial to restructure the DB schema: target a WORM layout, going for one record for each document (which I guess is unalterable after being sent/received) instead of going for a document-DB style adding each document to one in-record collection or bag of a "biz record", which I have seen sometimes in customer conflict cases.
>
>Then only added documents need to be replicated (deletion, if allowed, does incur less load) and adding document n+1 does not force re-replicating previous n documents bundled in that "record".
>However, no good deed goes unpunished: Queries will take longer, as all documents belonging to a biz case need a query to be seen ;-))

If documents have abstracts and/or short descriptions, I'd include those in the queries (actually, make them queryable) but not the documents themselves. Then allow the user to retrieve one document at a time.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform