Subject Re: [firebird-support] Re: Error Inserting data using .net
Author Helen Borrie
At 10:12 PM 4/10/2003 +0000, you wrote:
>Thank you for your reply.
>Do I need to always use transactions while using Firebird? I have seen
>some other posts which seem to indicate this.

Yes. Driver interfaces usually start a transaction for you if none
exists. However, you need to take care of the commit yourself in big
batches, especially if your server doesn't have a lot of memory
available. My guess is that your server crashes around 2000 uncommitted
inserts because you've maxed out the server's RAM.

Each driver interface has its own way of implementing the API. As Carlos
said, the right place to achieve what you need in your environment is the
firebird-net-provider list.