Hi, I'm not sure if this is a bug or a misconfiguration but I'm getting some really slow page generation times. I profiled it and a lot of time is spent in rollback which seemed odd.
Ordered by: internal time List reduced from 2017 to 100 due to restriction <100> Function was called by... ncalls tottime cumtime {method 'rollback' of '_mysql.connection' objects} <- 148 3.642 3.642 connmanager.py:89(restart_load) 147 3.613 3.613 storage.py:230(_rollback_load_connection) transform.py:149(transformIterable) <- 40 6.470 6.478 transformer.py:24(__call__) {method 'query' of '_mysql.connection' objects} <- 148 3.661 3.661 cursors.py:277(_do_query) ... The page itself is just a normal page, no writes involved. The mysql server is replicated master-slave. --- Dylan Jay Technical Solutions Manager PretaWeb: Multisite Performance Support P: +612 80819071 | M: +61421477460 | twitter.com/pretaweb | linkedin.com/in/djay75 _______________________________________________ For more information about ZODB, see http://zodb.org/ ZODB-Dev mailing list - ZODB-Dev@zope.org https://mail.zope.org/mailman/listinfo/zodb-dev