Re: [Quickfix-developers] Saving incoming messages: decision point

[Oren M. <ore...@ya...>]

John,
 
I tend to disfavor option number #1.  I can see the same database being shared by counterparties in internal systems.  For instance if an internal client is interacting with an internal server like an orderrouter, someone may make the decision to store everything in a central database.  Reversing the compids would make this difficult.
 
I would prefer #2.  I'm not concerned about the change in format, as these tables are really not designed for long term storage.  They are cleared out at the start of a session anyway, so it is reasonable to have people regenerate the table when upgrading.  Alternately a script can be provided that will convert the previous format to the new one.
 
--oren

John Muehlhausen <jg...@jg...> wrote:

All,

As I mentioned before, we are changing QuickFIX to support optional 
saving of incoming messages to the message store (via config 
parameter).

I see two options when it comes to the MySQLStore implementation:

1) reverse the sender and target IDs and create/update a record with 
that key
2) add another field to the key (messages table) which indicates 
incoming or outgoing

(1) may cause a problem if both sides of a session are using the same 
database-- for example, in testing

(2) involves a schema change which might cause some current users 
problems when upgrading to a future QuickFIX release that has this 
feature

Does anyone have a preference? I'm inclined to go with (1)...

Thanks,
John

PS-- the motivation for this is to help in applications that actually 
use the message store for other processing, such as in generation of 
OATS reports and for other audit procedures. I'm not sure that I want 
to use the MySQL log facility for this since it involves writing 
outbound messages to the database twice (= performance hit)... and 
could result in more than one entry per sequence number (= dups).



-------------------------------------------------------
This SF.net email is sponsored by: IBM Linux Tutorials.
Become an expert in LINUX or just sharpen your skills. Sign up for IBM's
Free Linux Tutorials. Learn everything from the bash shell to sys admin.
Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click
_______________________________________________
Quickfix-developers mailing list
Qui...@li...
https://lists.sourceforge.net/lists/listinfo/quickfix-developers

---------------------------------
Do you Yahoo!?
Find out what made the Top Yahoo! Searches of 2003