<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=DE-CH link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New";color:#1F497D;mso-fareast-language:EN-US'>Hi,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New";color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New";color:#1F497D;mso-fareast-language:EN-US'>well i dont know your programming skill, but if you need ms sql 2005 or the more recent 2012 then better go to:<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New";color:#1F497D;mso-fareast-language:EN-US'>database:<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New"'><a href="http://www.microsoft.com/en-us/sqlserver/default.aspx"><span lang=EN-US style='text-decoration:none'>http://www.microsoft.com/en-us/sqlserver/default.aspx</span></a><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New"'>serialize json<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New"'><a href="http://www.nuget.org/packages/eventstore.serialization.json"><span lang=EN-US style='text-decoration:none'>http://www.nuget.org/packages/eventstore.serialization.json</span></a></span><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New"'><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New"'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New"'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New"'>we love to work in the object oriented way, especially with JSON<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New"'>database:<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New";color:#006621;background:white'><a href="http://www.mongodb.org"><span lang=EN-US style='text-decoration:none'>www.mongodb.org</span></a></span><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New";color:#006621;background:white'><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New";color:#006621;background:white'><a href="http://www.couchbase.com"><span style='text-decoration:none'>www.couchbase.com</span></a></span><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New";color:#1F497D;background:white'><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New";color:#1F497D;background:white'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New";color:#1F497D;background:white'>we prefer couchbase since it’s got in-memory db functionalities<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New";color:#1F497D;background:white'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New";color:#1F497D;background:white'>but in this list we can help you only how to handle qfn but we can’t help you what db you need or how you’re store data into a db. That should be your part as a programmer. The qfn data can be stored everywhere you like. One of my project even uses a flat file store to avoid db over heads.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New";color:#1F497D;background:white'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New";color:#1F497D;background:white'>If you’re a c# programmer I also would consider to have a look at the TPL<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New";color:#1F497D;background:white'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New"'><a href="http://msdn.microsoft.com/en-us/library/dd537609(v=vs.110).aspx"><span lang=EN-US style='text-decoration:none'>http://msdn.microsoft.com/en-us/library/dd537609(v=vs.110).aspx</span></a><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New"'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New"'>to make the app more responsive and faster, in case you’re fix feed sends you too much data at once.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New"'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New"'>Thanks,</span><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New";color:#1F497D;background:white'><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New";color:#1F497D;background:white'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New";color:#1F497D;background:white'>Walter.</span><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New";color:#006621;background:white'><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New";color:#006621;background:white'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New"'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New";color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New";color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New";color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New";mso-fareast-language:EN-US'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New"'>From:</span><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New"'> quickfixn-bounces@lists.quickfixn.com [mailto:quickfixn-bounces@lists.quickfixn.com] On Behalf Of vishvesh raval<br>Sent: Montag, 2. Dezember 2013 11:36<br>To: Mailing list for QuickFIXn<br>Subject: Re: {{Quickfixn}} how to store the FIX message into the database<o:p></o:p></span></p></div></div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New"'><o:p> </o:p></span></p><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New"'>hi walter, <o:p></o:p></span></p><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New"'> sorry that i posted the question in wrong list. I am new to these things.can you please guide me or give me link for the correct list to post the question.I will be very grateful to you for your help.I really need help in this matter.Sorry for your inconvenience.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New"'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New"'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New"'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New"'>Thanks & Regards,<o:p></o:p></span></p></div><div><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:11.0pt;font-family:"Courier New"'>Vishwesh Raval.<o:p></o:p></span></p><div><div class=MsoNormal align=center style='text-align:center'><span style='font-size:11.0pt;font-family:"Courier New"'><hr size=2 width="100%" align=center id=stopSpelling></span></div><p class=MsoNormal style='margin-bottom:12.0pt'><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New"'>CC: </span><span style='font-size:11.0pt;font-family:"Courier New"'><a href="mailto:quickfixn@lists.quickfixn.com"><span lang=EN-US style='text-decoration:none'>quickfixn@lists.quickfixn.com</span></a></span><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New"'><br>From: </span><span style='font-size:11.0pt;font-family:"Courier New"'><a href="mailto:ditwal001@gmail.com"><span lang=EN-US style='text-decoration:none'>ditwal001@gmail.com</span></a></span><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New"'><br>Date: Mon, 2 Dec 2013 09:20:50 +0100<br>To: </span><span style='font-size:11.0pt;font-family:"Courier New"'><a href="mailto:quickfixn@lists.quickfixn.com"><span lang=EN-US style='text-decoration:none'>quickfixn@lists.quickfixn.com</span></a></span><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New"'><br>Subject: Re: {{Quickfixn}} how to store the FIX message into the database<o:p></o:p></span></p><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New"'>hi,<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New"'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New"'>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.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New"'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New"'>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.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New"'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New"'>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.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New"'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New"'>but i guess there are much better list out there to answer u that question.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New"'>thx<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New"'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New"'>walter.<o:p></o:p></span></p></div><div><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:11.0pt;font-family:"Courier New"'><br>On 02 Dec 2013, at 06:54, vishvesh raval <<a href="mailto:vishveshraval@hotmail.com"><span style='text-decoration:none'>vishveshraval@hotmail.com</span></a>> wrote:<o:p></o:p></span></p></div><div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New"'>hi sir,<o:p></o:p></span></p><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New"'> i have one query about quickfix messages.i will be very grateful if you give your valuable guidance to me.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New"'> 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.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New"'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New"'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New"'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New"'>Thanks & Regards,<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New"'>Vishwesh Raval<o:p></o:p></span></p></div></div></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New"'>_______________________________________________<br>Quickfixn mailing list<br><a href="mailto:Quickfixn@lists.quickfixn.com"><span style='text-decoration:none'>Quickfixn@lists.quickfixn.com</span></a><br><a href="http://lists.quickfixn.com/listinfo.cgi/quickfixn-quickfixn.com" target="_blank"><span style='text-decoration:none'>http://lists.quickfixn.com/listinfo.cgi/quickfixn-quickfixn.com</span></a><o:p></o:p></span></p></div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New"'><br></span><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New"'>_______________________________________________ Quickfixn mailing list </span><span style='font-size:11.0pt;font-family:"Courier New"'><a href="mailto:Quickfixn@lists.quickfixn.com"><span lang=EN-US style='text-decoration:none'>Quickfixn@lists.quickfixn.com</span></a></span><span style='font-size:11.0pt;font-family:"Courier New"'> </span><span style='font-size:11.0pt;font-family:"Courier New"'><a href="http://lists.quickfixn.com/listinfo.cgi/quickfixn-quickfixn.com"><span lang=EN-US style='text-decoration:none'>http://lists.quickfixn.com/listinfo.cgi/quickfixn-quickfixn.com</span></a></span><span lang=EN-US style='font-size:11.0pt;font-family:"Courier New"'><o:p></o:p></span></p></div></div></div></div></body></html>