[Zope-dev] Re: When should one call Connection.sync?

[Syver Enstad]

Dieter Maurer <dieter at handshake.de> writes:

> Syver Enstad wrote at 2004-4-21 18:03 +0200:
> >I have done some experiments with this scheme and I find that
> >everything gets unloaded when do a connection.close() or
> >connection.sync() so that performance takes quite a hit.
> 
> Maybe, the connection cache is too small.
> 
> Usually, an incremental cache garbage collection is performed
> in "connection.close()" and at transaction boundaries
> ("sync" causes an implicit "transaction.abort()" which means,
> it marks a transaction boundary). The cache garbage collection
> tries to flush as many objects from the cache as are necessary
> to reach the target cache size.

Yes that was the problem, I found out about this after some
experiments and by upping the cache_size to at least 20 000 I manage
to keep the instances in memory even when I do a sync or close.

Thank you anyway.