Question about Pyramid + ZODB + RelStorage performances about relstorage HOT 2 CLOSED

In our experience running a very large, very active site, we didn't find performance degradation associated with just being up and processing transactions, assuming consistent transaction sizes. I wouldn't consider such degredation normal.

I would probably first start by increasing the various cache sizes (the ZODB connection's ghost cache, the RelStorage internal pickle cache). (You could also look to make sure you don't have any idle-in-transaction connections open to the database.)

But that's a shot in the dark without knowing much, much more about your application's behaviour. To find out more, look at the metrics that RelStorage produces by hooking it up to a StatsD/Graphite system with a visualization front-end (graphite itself comes with a simple one). See also the perfmetrics package documentation. RelStorage can also be configured to log some interesting performance information as well; this configuration is usually handled with environment variables (of which RelStorage supports many!). Many environment variables are documented (in the release notes and/or API documentation), but if you have the relstorage logger configured at debug level when RelStorage is imported, all the environment variables it reads will be logged.

Good luck!

from relstorage.

Hi Jason,
As I use a quite huge catalog, I actually increased the RelStorage cache size and everything seems much better now!
Thank you anyway for all your advises!
Best regards,
Thierry

from relstorage.