Re: SQL and real time systems
Date: Mon, 06 Jan 2003 21:14:52 -0500
Message-ID: <3E1A381C.8050909_at_idirect.com>
--CELKO-- wrote:
>>>Any comments on the suitability of using an sql database in a real
>>>
> time system ... In my mind it doesnt seem suitable becaause of the
> memory usage and the amount of real time used in performing queries.
> <<
>
> I would not do that. Most RT applications will be doing straight data
> capture from a few (usually one) sources and you will not share it
> with anyone else. Speed is the most important thing in RT
> applications, while data integrity, sharing, etc. are what is
> important in an OLTP application.
Well, to be picky about terminology, at least about what words *should* mean <grin> ...
What a real-time system requires is not necessarily great speed, but rather predictable speed. And so Joe's recommendation stands.
>
> Stuff your data into a file in your RT/OS, scub it, then move it over
> to an analysis tool or a database later.
>
Received on Tue Jan 07 2003 - 03:14:52 CET