Hello,
This is probably for the real firebird professionials: :)
I have a device producing around 30000 smallint values per sec for hours.
The idea is to store the data in compressed blobs in a LOCAL database with embedded server.
1. Is having a single blob compressed by a server side filter a good idea considering
1.1 possible power failures? What happens to the blobs beeing written to at the moment of power failure when the server restarts? How does ACID comply here?
1.2) when displaying the stored compressed data, we need to find the data for a specific second, and this should be really fast.
2. If point 1 is ruled out, I could use some suggestions how to design a table to hold compressed chunks of the data in separate records to make the time based access of portions of the data as fast as possible, while keeping the disk requirementes low.
3. Any other idea, suggestion, hint?
I badly need advice from experienced people with this. :)
CC
