Subject | When do FB/IB 'flush' to disk? |
---|---|
Author | Phil Shrimpton |
Post date | 2001-11-27T12:57:26Z |
Hi,
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?
Cheers
Phil
--
Linux 2.4.4-4GB
12:50pm up 34 days, 6:01, 1 user, load average: 1.13, 0.26, 0.08
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?
Cheers
Phil
--
Linux 2.4.4-4GB
12:50pm up 34 days, 6:01, 1 user, load average: 1.13, 0.26, 0.08