Subject When do FB/IB 'flush' to disk?
Author Phil Shrimpton

When using using FB (and IB) with forced writes OFF on Windows, it never
seams to 'flush' commited data to the *.gdb file until the client
disconnects. This does not seam to be a problem under Linux.

We have an app that is constantly importing data to a database, an although
we are commiting every couple of thousand records, the *.gdb file size never
increases until we close the apps database connection. This leads to a GDB
file(s) that has 500Mb of data in it to only be 3Mb in size.

Is there anyway to 'force' a flush to disk, other than re-connecting?



Linux 2.4.4-4GB
12:50pm up 34 days, 6:01, 1 user, load average: 1.13, 0.26, 0.08