Thebetter solution is to have a document_in_progress table. When the user
isdone revising a document, the application moves it from the
document_in_progresstable to the replicated table. Theresults in a single
update(200 kb of messages).
Controllingreplication of
blobs TheAdaptive Server Anywhere BLOB_THRESHOLD option allows further
controlover the replication of long values. Anyvalue longer than the
BLOB_THRESHOLDoption is replicated as a blob. Thatis, it is broken
intopieces and replicated in chunks, before being reconstituted by using a
SQLvariable and concatenating the pieces at the recipient site.
Bysetting BLOB_THRESHOLD to a high value in remote Adaptive Server
Anywheredatabases, blobs are not broken into pieces, and operations can be
appliedto Adaptive Server Enterprise by the Message Agent. EachSQL
statementmust fit within a message, so this only allows replication of small
blobs.
Replication of dates and times
Whendate or time columns are replicated, the Message Agent uses the
settingof the SR_Date_Format, SR_Time_Format, and
SR_Timestamp_Formatdatabase options to format the date.
Forexample, the following option setting instructs the Message Agent to
senda date of May 2, 1987 as 1987-05-02.
SET OPTION SR_Date_Format = ’yyyy-mm-dd’
☞Formore information, see “SQL Remote options” on page 315.
Thefollowing points may be useful when replicating dates and times:
♦Thetime, date, and timestamp formats must be consistent throughout the
installation.
♦Ifthe consolidated database is an Adaptive Server Anywhere database,
ensurethat the order of year, month, and day used for the date and
timestampformats matches the setting of the DATE_ORDER database
option.
Youcan change the DATE_ORDERoption for the duration of each
connection.
♦Ifthe consolidated database is an Adaptive Server Enterprise database,
ensurethat the order of year, month, and day in the SQL Remote settings
isconsistent with the dateformat setting in the Adaptive Server Enterprise
database.
84