Subject Re: [ib-support] When do FB/IB 'flush' to disk?
Author Phil Shrimpton
On Friday 30 November 2001 15:57, you wrote:


> > > What is volume of imported data ?
> >
> > about 200Mb per day
> You need about 30 hours to import ONLY 200Mb ???

For each record imported there can be up to 75 'lookups' and/or insertions,
and up to 50 calculations, all done in stored procedures.

> Have you tried to tune the db enough ? Like not count all rows in each
> trigger :-), drop fk constraints with low selectivity indexes, and such
> things ? (or more nasty tricks like denormalize the tables ...)

The database works very will on Solaris and Linux, but we just have a
potential customer that wants to run the thing on Windows, and I not keen on
writting a 'special versin' just for him.


Linux 2.4.4-4GB
5:18pm up 6:12, 1 user, load average: 0.82, 0.32, 0.19