I'm developing an app that will collect and display real-time market data. This data often times arrives is surges at which time maintaining minimum cpu utilization is important therefore I'm concerned about Insert performance.
I'm thinking some type of caching scheme would be appropriate where the quotes accumulate in the cache and would be periodically updated. I need to display the real-time quotes and display real-time charts with history, therefore I need to be able to read the cached data and the persisted data on chart refreshes. I'm guessing this is not that unique of a requirement and therefore don't want to reinvent the wheel. This will be a single user app with no near term plans for any type of client server architecture therefore an embedded type solution would be preferred especially if higher performance (lower cpu utilization) can be achieve with an embedded solution. I'm somewhat of a rookie with databases and would appreciate any thoughts and suggestions on how to structure this or any specific database suggestions. shawn _______________________________________________ Delphi-DB mailing list [email protected] http://www.elists.org/mailman/listinfo/delphi-db
