Subject Re: [ib-support] When do FB/IB 'flush' to disk?
Author Phil Shrimpton
On Thursday 29 November 2001 23:27, you wrote:

Hi,

> > Too slow, is the simple answer.

> What is volume of imported data ?

about 200Mb per day

> How many rows

millions

> how many blobs ?

none

> Any triggers, fk constraints, indexes involved ?

loads

> Have you tried to use database with preallocated space ?

Yes.

The app works fine under Linux/Solaris, and the only problem I have with it
running on Windows is the fact that this data is never flushed to the GDB
files.

As a work around, I have set the importer app to disconnect and reconnect at
midnight every day, which is a minor bit of code, really, but it should not
have to be done. The is a Windows issue, not FB/IB, all too often Windows
leaves stuff upto the programmer to do that should be done by the OS.

Phil

--
Linux 2.4.4-4GB
12:39am up 1 day, 7:29, 1 user, load average: 0.54, 0.31, 0.30