Terry Boyd 27.Nov.07 03:52 AM a Web browser Applications Development 6.0.3 All Platforms
We have a distributed KnowledgeBase database.
There are not that many documents (<4k), but some of them are quite large (5 - 10MB).
We have been testing some new functionality which allows authors to re-assign documents to different "areas" or "document admins" - Essentially just changing the value of a single field on the document.
We have found, however, that by changing that one field, we are causing the replication of the entire document content to all of our users (some 1,500 people). This will cause some serious traffic spikes if we perform some "blanket" document cleanups!!
Now, there is only ONE circumstance where this holds true...
This is only evident when the rich text field on the document contains embedded images (well, sofar we've only seen images embedded on the documents in question).
If the rich text field contains attachments, or simply formatted text, then only the document field changes - a matter of a few KB vs. 10MB - are replicated (very minimal traffic).
The design of the database form calls for replication conflicts to be merged (if that has any bearing at all with this issue).
Is there anything we can do to prevent the replication of the entire document for documents which have embedded content in a rich text field?
Is there something that we have incorrectly setup in the database design?
Any and all suggestions would be greatly appreciated!