Subject RE: [ib-support] When do FB/IB 'flush' to disk?
Author Bill Morrison
I was thinking the same thing, a stress test app I had running last night
with Forced Writes On imported about 50 gigs in 15 hours or so (crummy
Celeron system with cheesy IDE HD).

Granted I'm just shoving data in without doing much other processing, but
still it might indicate that the bottleneck might be elsewhere.



-----Original Message-----
From: Ivan Prenosil [mailto:prenosil@...]
Sent: Friday, November 30, 2001 7:58 AM
Subject: Re: [ib-support] When do FB/IB 'flush' to disk?

>>> With forced writes OFF it takes about 8-9 hours to import a days
>>> data, with them ON it takes 3-4 times as long (which is longer than a
> > > Too slow, is the simple answer.
> > What is volume of imported data ?
> about 200Mb per day

You need about 30 hours to import ONLY 200Mb ???

Then you should upgrade your 80286 :-)

> > How many rows
> millions
> > how many blobs ?
> none
> > Any triggers, fk constraints, indexes involved ?
> loads

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 ...)


To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to