Subject Re: Performance when deleting a lot of records, again
Author cosamektoo
The default option in sqlapi is CommitRetaining=false.(As written in
the documentation :

I've also set this option hard coded to false just to make sure.
But still, only reconnecting once in a while works arround this

--- In, "mikcaau" <macomp@s...>
> --- In, "cosamektoo"
> wrote:
> >
> > 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
> > The only workarround that I found is to disconnect and reconnect
> > 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
> 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
> happening.
> Mick