Subject Firebird in automation
Author Michele Cannella
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