Subject RE: [ib-support] Ib faster than FB for inserting blob ?
Author Philippe Makowski
Leyne, Sean wrote:
>
> Philippe,
>
> > someone in France made a test inserting a large amount of
> > blob (jpeg size of 100 ko to 1Mo)
> > with FB 1.0 (796-win32) an Ib 6.01
> > with about 30000 insert this take 2h30 with FB and 1h30 with IB
> > (test made with Delphi TIBsql)
> > any comment or explanation ?
>
> Did the test involve creating the database from scratch?
>
I think yes

> If so, IB does not set ForceWrites = True by default. Whereas, FB does.
> Setting ForceWrite = True make for a completely reliable db.
>
> This would more that explain the timing differences.
>
thanks, I did not thought about this difference, I rely the explanation