Re: [Quickfix-developers] To database or not to database

[Eranga S. <pe...@ri...>]

Hi,

Here are some of test results I got through my test. Testing environment not
up to standard. I just use my working machine.
I used Quickfix through the JNI.
Machine 3 GHz processor 1GB DDR RAM.
Both Quickfix and MySQL server running on same machine.

Rds,

Eranga




File storage
Number of Active sessions	Number of messages 	Total time / s
Messages per Second
1						10,000		156.2
64.02
1						25,000		391.3
63.88
1						50,000		783.6
63.80
10						10,000		156.5
63.89
10						25,000		391.4
63.87
10						50,000		783.6
63.80

MySQL storage

Number of Active sessions	Number of messages		Total time /
s 	Messages per Second
1							10,000	449.7
22.23
1							25,000	1146.2
21.81
1							50,000	2282.7
21.90
10							10,000	440.0
22.72
10							25,000	1074.1
23.27
10							50,000	2161.5
23.13

-----Original Message-----
From: qui...@li...
[mailto:qui...@li...] On Behalf Of
Ronald StOnge
Sent: Friday, February 16, 2007 8:49 AM
To: qui...@li...
Subject: [Quickfix-developers] To database or not to database

QuickFIX Documentation:
http://www.quickfixengine.org/quickfix/doc/html/index.html
QuickFIX Support: http://www.quickfixengine.org/services.html

I am working on a financial application and am
planning to use QuickFIX.  I got the project and
example working just find (nice job putting this
together!).

My application will only need to process about 100
messages a second.  What are the pros/cons of using a
database such as PostgreSQL vs. a flat file for the
message store (reliablility is a priority for me vs.
speed)?

Thanks,

Ron



 
____________________________________________________________________________
________
No need to miss a message. Get email on-the-go 
with Yahoo! Mail for Mobile. Get started.
http://mobile.yahoo.com/mail 

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Quickfix-developers mailing list
Qui...@li...
https://lists.sourceforge.net/lists/listinfo/quickfix-developers