Hi,

I'm an entry level developer and with very little experience with DTN...I wanted to know if anyone had has any sample code that they can provide me with showing how you're using the feed in conjunction with a database.

I'm current "trying" to parse the feed and insert the the results in a MySQL database and I'm also querying the database and displaying the results on the front-end via a C# client app that I'm working on but I'm having a lot of trouble with performance, consistency, etc...

Basically I'd just like to look over some code with interaction between the a front-end, DNT and a database.

Thanks,

Hi,

Depending on a few factors (number of symbols, frequency of the data) it's likely that a formal SQL database on the same machine as your front end is the wrong solution.

From memory, make sure you are using the correct MySQL engine that allows for proper consistency (I can't remember which one). Performance wise, do bulk inserts rather than 1 row at a time etc.

If you *need* to use a database I'de suggest using a c# memory based object that you can add to 'cheaply' as data arrives, and use this object to populate the display. Every so often (via a different thread) you can dump the data to the database.

Regards,

Red.

Hi,
Thanks Red, hey give you show me an example of what you're talking about?