Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multi-Site Database Replication - SQL Server
Message
From
01/05/2017 14:06:44
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
01/05/2017 08:00:37
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows Server 2012 R2
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01650658
Message ID:
01650737
Views:
31
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform