Too many MySQL queries - community.ez.no

Tuesday 16 October 2007 9:34:23 am - 5 replies

5 replies

Author	Message
Pascal France	Tuesday 16 October 2007 9:46:22 am On the same machine, I've installed a fresh ezp 3.9.3 with ezwebin. By default, the Total script time of the content tree is about 2 sec and the MySQL queries count is 10 Where does come from such a difference ? Pascal Ce qui embellit le désert c'est qu'il cache un puits... quelque part... (A. de Saint-Exupéry) - http://luxpopuli.fr/eZ-Publish
Damien Pobel	Tuesday 16 October 2007 11:51:46 pm Hi Pascal, Did you check permissions on the var directory and its sub directories ? Did you check the ViewCaching setting in site.ini and others cache related settings (*Cache) ? By default, UsePersistentConnection is disabled, I don't if this settings has good (or bad) effects on performance. Perhaps you can set DebugOuput to enabled and paste here the result ? Damien Planet eZ Publish.fr : http://www.planet-ezpublish.fr Certification : http://auth.ez.no/certification/verify/372448 Publications about eZ Publish : http://pwet.fr/tags/keywords/weblog/ez_publish
André R.	Wednesday 17 October 2007 12:33:13 am Please install ezjaxx extension or upgrade to 3.10/4.0 where you also have a dynamic content tree menu. eZ Online Editor 5: http://projects.ez.no/ezoe \|\| eZJSCore (Ajax): http://projects.ez.no/ezjscore \|\| eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription @: http://twitter.com/andrerom
Pascal France	Wednesday 17 October 2007 2:56:46 am Hi André, Will this solve the problem of the long long time (30-40 sec) the system takes to edit or save an article (or any other object), even its content is short ? Pascal Ce qui embellit le désert c'est qu'il cache un puits... quelque part... (A. de Saint-Exupéry) - http://luxpopuli.fr/eZ-Publish
André R.	Wednesday 17 October 2007 3:25:27 am It should help quite a lot on this: The refresh time of my collapsed content tree take about 25s and 350 mysql queries. so when you browse around or when you hit 'publish' after editing some content. Edit: Editing performance is also further increased in ezp4.0 thanks to php 5.2 and use of native xml in php 5 instead of ezxml. eZ Online Editor 5: http://projects.ez.no/ezoe \|\| eZJSCore (Ajax): http://projects.ez.no/ezjscore \|\| eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription @: http://twitter.com/andrerom

You must be logged in to post messages in this topic!