Subject DB > 2Go
Author Fabrice Aeschbacher
Hi,

Firebird version: LI-V6.2.908 Firebird 1.0 (classic-64)
OS: Linux/debian kernel 2.4.20
Filesystem: XFS

I am storing video in a database and having some trouble with very
large db files.
Here is my db file:

# ls -l /database/
total 8470252
-rw-r--r-- 1 firebird firebird 9492928000 May 13 11:25 video.gdb

- I cannot backup a database: gbak ends with the following error
message: File size limit exceeded

- gstat simply don't work and says: "File too large"

- The effective video data stored in the db is 4,4Gb. New data records
are continually inserted, old data records continually deleted, so
this size does not grow. However, the size of the database is allways
growing. Why? (each video record is a blob subtype 0 containing 10Mb
of the video bitstream; I could easily change this value if needed).

All the rest works great, I am recording 6 cameras since a week, being
able to replay each video sequence. However, if the db is growing so
much over the real video size, then FB is not appropriate for our
needs, OR I'll have to store the video slices outside the DB (into
files), which I would not prefer.

Any hint on this could help.

Best regards,
Fabrice Aeschbacher