Storing and Reading Data

[funk101]

I have successfully created my own chart overriding Plot() etc. Question now is how best to store my data? IE: everytime I hit F5, the chart refreshes, and I lose all my past data, and it starts all over again. What is the optimal way to do this? StreamReader/Writer? Storing in a DB table? I'm just asking what is the most optimal way, I've successfully used both methods, so I understand how to do it just not sure which is the "best" way to do this performance-wise, etc.

[NinjaTrader_RyanM1]

Hello funk101,

Unfortunately we do not have specific performance guidelines available. For implementation, you may want to look into this SQL sample provided by one of our members. May also want to look into the GOMI recorders available on these forums as well.

[funk101]

Which is better to distribute?

If one needs to store historical OnMarketDepth() / OnMarketData() bid/ask/volume info, is it better to do so via writing data to the filesystem using StreamReader/StreamWriter or simply recording rows in a database? Keeping in mind that this would be distributed as an indicator to clients. (I'm not asking 'how' to do it, just what is the 'better' way for distribution, opinions welcome.) :-)

[koganam]

If one needs to store historical OnMarketDepth() / OnMarketData() bid/ask/volume info, is it better to do so via writing data to the filesystem using StreamReader/StreamWriter or simply recording rows in a database? Keeping in mind that this would be distributed as an indicator to clients. (I'm not asking 'how' to do it, just what is the 'better' way for distribution, opinions welcome.) :-)

I will make a suggestion by asking a question or two.

How certain can you be that all your clients will either already have whatever database you are using installed, or be willing to install it?

Can you tolerate the loss of business from those who decline to install the database?

[funk101]

Well, along with the .NET runtime, and NT, doesn't an embedded SQL Server get distributed?