Subject Re: Performance when deleting a lot of records, again
Author mikcaau
--- In, "cosamektoo" <gbuzaglo@c...>
> Hi and thanks
> It seems to me that there is a bug in SQLAPI library.
> When I dont connect the client through this library,
> the numbers of next transaction and last snapshot stay close together.
> The only workarround that I found is to disconnect and reconnect the
> SQLAPI db connection every X minutes.I think that even though I
> commit every read operation through that connection, it causes
> the database to keep transactions open.
> What do you think about this conclusion ?
> Thanks
> -gili
I don't use SqlApi. You need to make sure that you are not
CommitRetaining because that will keep a reference to the record.
I assume you have the source so you can trace it back and see what is