Subject | Firebird in automation |
---|---|
Author | Michele Cannella |
Post date | 2004-12-01T13:08:54Z |
Hi all
I am trying to use firebird in an automation environment. A set of
measures taken from the field must be continuously written to the db.
Each second aroung 1000 measures must be added to a table like
that:
signal_id (integer)
hour (datetime)
value (double)
quality (integer)
I am using C++ in a Windows NT/2000 environment (Visual C++,
wxWindows, ibpp library). And the idea is to keep around 300000 values
for each signal
There are performance problems: it seems that the system cannot add so
many record each second (but 1000 are too much ?)
Someone could suggest some 'trick' to keep using firebird for this job ?
thanks
Michele
I am trying to use firebird in an automation environment. A set of
measures taken from the field must be continuously written to the db.
Each second aroung 1000 measures must be added to a table like
that:
signal_id (integer)
hour (datetime)
value (double)
quality (integer)
I am using C++ in a Windows NT/2000 environment (Visual C++,
wxWindows, ibpp library). And the idea is to keep around 300000 values
for each signal
There are performance problems: it seems that the system cannot add so
many record each second (but 1000 are too much ?)
Someone could suggest some 'trick' to keep using firebird for this job ?
thanks
Michele