[fpc-pascal] Looking for a Firebird book?

[Matt Emson]

Marco van de Voort wrote:
>> On Wed, 9 Apr 2008, Matt Emson wrote:
>>
>> The only negative thing I can say about Firebird is that it can produce
>> a corrupt backup file.
>>     
>
> IIRC Mass insertion could bring down the db (slow to an effective DOS to
> other users) unless you commit the transaction every 10000 items or so.

Yep, we definitely saw that. We ended up going a little insane with 
committing transaction (bad original design relied on keeping 
transactions open slightly too often.) Even so, the Delphi controls we 
used (Delphi 5, whatever the latest IBExpress Borland shipped) were 
appalingly buggy wrt transactional stuff. I always liked the other ones, 
IBObjects, personally - even if they were quite odd. IBExpress could not 
handle the server disconnecting - totally unrecoverable. IBO did handle 
it quite well.

M