|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 day)
> > > Too slow, is the simple answer.You need about 30 hours to import ONLY 200Mb ???
> > What is volume of imported data ?
> about 200Mb per day
Then you should upgrade your 80286 :-)
> > How many rowsHave you tried to tune the db enough ? Like not count all rows in each trigger :-),
> > how many blobs ?
> > Any triggers, fk constraints, indexes involved ?
drop fk constraints with low selectivity indexes, and such things ?
(or more nasty tricks like denormalize the tables ...)