Too many MySQL queries

Tuesday 16 October 2007 9:34:23 am

Hi,

I've a trouble with the speed of the admin interface.

The refresh time of my collapsed content tree take about 25s and 350 mysql queries.
And this time is at least the same each time I want to do something from the contextual menu.

After I read these posts:

http://ez.no/developer/forum/general/ez_publish_performance_optimisation_faq/(offset)/20
http://ez.no/developer/forum/developer/i_read_all_about_ez_performance_but_admin_part_is_slow

...the settings of my admin site.ini.append.php are:

[TemplateSettings]
TemplateCache=enabled
TemplateCompile=enabled
TemplateOptimization=enabled
Debug=disabled
ShowXHTMLCode=disabled
ShowUsedTemplates=disabled

[DebugSettings]
DebugOutput=enabled
DebugRedirection=disabled

[DatabaseSettings]
UsePersistentConnection=enabled

My content tree contains about 180 objects.

In the second post above, Łukasz Serwatka says
"content/view/full/2 in admin usually takes around 12 SQL queries on cached site" !

I run:

ez publish 3.9.3
apache 1.3.37
PHP 4.4.7
eaccelerator

On the public wed side, the Total script time is about 1.2 sec for each page

What more could I do thant I already done ?

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

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

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