Hi,
I am using the ODBC mesage log, and my underlying database is SQL
Server 2000. I realized during my testing that the messages logged in
the messages table of my buy-side logs were getting deleted upon each
reset. I was planning on writing a DELETE trigger to copy those rows
over to a parallel table that I can use to archive those messages
permanently, but SQL Server does not support the use of columns of TEXT
datatype in triggers.
Is it absolutely necessary to use TEXT in this column instead of a
slightly smaller variable-length character datatype like varchar? I know
that this may be a limitation specific to SQL Server.
Do you recommend the use of field 383, sent during the logon, to limit
the size of all messages to some value like 8k? What is the reasonable
limit that one might expect for real-world FIX messages?
thx
George Coles
|
