Dieter Maurer <dieter@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.