|Subject||RE: [firebird-support] Re: multiple inserts in trigger|
> Does anyone know how expensive it is to fire off 50 triggersI don't understand exactly what you are trying to accomplish but rule of
> on an update
> that do a single insert to a table as oppose to inline code
> that tests for
> 50 cases and one trigger fired? Is firing a trigger in
> firebird lightweight
> of heavy?
thumb is to have your code inside tha database against client code. That way
you avoid network traffic and gain speed and maintainability.
On the other hand, 50 triggers probably means you should consider
redesigning your database. Of course, that might not be an option for you
but be aware that you will hardly get any performance by patchworking bad
Those are just recomendations, nobody can really tell you what will work
best for you. In any case, you need to test it in *your* real environment.
And as for your original problem, it should work so don't give up so easily.
You could provide us with some minimal test script that will create the
database and setup a test case for problematic trigger.