{{Quickfixn}} how to store the FIX message into the database

[Walter Robert Ditzler]

hi,

i dont know if this is the right list for that queston! basicly what do u want to store? everything then go into "fromapp" qfn event or specific qfn data then use one of the qfn message event's.

for the data and compatibility we store it as a serialized json object in a oodb. if u need to use relational db then maybe use one column for the serialized string and other designed colums for ur search criterias since search ops on char is a overhead ops.

for the database personally we use mem cache base document store "couch base" or "mongodb". it depends on what speed you need or interval the fix data is comming in onto your end.

but i guess there are much better list out there to answer u that question.
thx

walter.

On 02 Dec 2013, at 06:54, vishvesh raval <vishveshraval at hotmail.com> wrote:

hi sir,
  i have one query about quickfix messages.i will be very grateful if you give your valuable guidance to me.
                                     I want to know that how to store the FIX message into the database to keep the log of the transferring message in sql server 2005. Is it to store whole message into the single column of the table or store the whole message in the Tag value format i.e. column names should be tag names or tag values and actual transferring message values in the row. can anyone give me suggestion on it. Thanks in advance.



Thanks & Regards,
Vishwesh Raval
_______________________________________________
Quickfixn mailing list
Quickfixn at lists.quickfixn.com
http://lists.quickfixn.com/listinfo.cgi/quickfixn-quickfixn.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.quickfixn.com/pipermail/quickfixn-quickfixn.com/attachments/20131202/73604046/attachment-0002.htm>