Re: SQL and real time systems

From: Terrence Enger <tenger_at_idirect.com>
Date: Mon, 06 Jan 2003 21:14:52 -0500
Message-ID: <3E1A381C.8050909@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 Mon Jan 06 2003 - 20:14:52 CST