Re: [Firebird-net-provider] Firebird crash due to .Net provider?

[<and...@sp...>]

I am using an explicit transaction. I tried to insert all data using one 
transaction and I tried to commit after each insert.

*André Jager*



Ruben Guinez wrote:

> When you do insert, are you use default transaction?, o explicit 
> transaction?
>
> On 10/31/05, *André Jager* <and...@sp... 
> <mailto:and...@sp...>> wrote:
>
>     Hello,
>
>     I am developing software with c# / Firebird / .Net provider and
>     noticed the following behaviour:
>
>     I have a loop creating 16.000+ insert statements to fill a table.
>     When I run this program, Firebird memory consumption on the server
>     jumps from 5 mb to about 120 mb. When I close the connection on
>     the client programm, memory requirement drops to 20 mb. When I
>     close the .Net program, memory consumption drops to 5 mb.
>
>     However, most of the time the Firebird server crashes. Eventlog
>     entry: Abnormal Termination:
>     C:\Programme\Firebird\Firebird_1_5\bin\fbserver.exe: terminated
>     abnormally (4294967295).
>
>     At first I thought it was a Firebird problem, but after spending a
>     few hours with this problem, I think it is a .Net provider bug.
>
>     I am looking for sugestions on how to proceed to find out if it is
>     a .Net provider problem and how to pin down the bug.
>
>     thanks,
>
>     *André Jager*
>
>
>
>
> -- 
> Rubén D. Guíñez G.
> Software Developer