ChartDirector Support - View Thread 1358144289

ChartDirector Support

Search

[Jan-14-2013 14:18] Building chart from data base (oded orbach)
- [Jan-15-2013 02:53] Re: Building chart from data base (Peter Kwan)

Building chart from data base
Posted by oded orbach on Jan-14-2013 14:18	\| Reply \| Monitor
hello Peter, Which is the best way to save 1 save 1 second interval data to data later use? today i'm using ms accsess with SQL queries. is there a safer and faster way? i get to 2 GB of data real quick and loading is slow. i keep 60 data columns each trading srecond (28800 total) per day. Thanks Oded

Re: Building chart from data base

Posted by Peter Kwan on Jan-15-2013 02:53

Hi oded,

It depends on your requirements. Saving data as a binary file is the fastest method to save the data. You may also use plain text file, which is a little bit slower. However, it is only fast to save the data, but slow to retrieve the data. There are also other considerations, such as concurrent access, data integrity, ability to update, ability to delete or modify the data, indexing, complex querying, data management, etc.. You would need to choose the system that best fit all of your needs.

Regards
Peter Kwan