OptimizeOnCommit enabled implies long publishing time?

Author Message

Carlos Revillo

Tuesday 14 April 2009 7:56:21 am

Hi. I think i'm doing something wrong with eZ Find. I'm working with the last rev from the repo btw.

After i enabled eZ find extension, all the publishing process takes a lot of time. I'm talking about 30 - 45 seconds...

This is not good for me, because in this site there will be a lot of content coming not only from the editors but also from guest accounts users.

Disabling OptimizeOnCommit option publishing is faster. Only 3-4 seconds.

I now i can disable this and set a cron to optimize, but is this normal? I mean, is normal that these optimize operations takes so long?

This is not a very big site at the moment (development stage). It's a bilingual site right now, but more languages will be added. think about less than 1000 objects right now.

I'm using ubuntu and i have 3GB memory.

Thanks in advance.

Xavier Serna

Thursday 16 April 2009 12:38:43 am

Hi Carlos,

this is the same problem here with big indices. Each Optimize operation causes a regeneration of the whole index files, it's the reason for this publishing delay.
I believe that disabling optimize on commit and optimizing indices via cronjob once a day it's ok, we have these setup here too.

regards!

--
Xavier Serna
eZ Publish Certified Developer
Departament de Software
Microblau S.L. - http://www.microblau.net
+34 937 466 205

Carlos Revillo

Thursday 16 April 2009 12:47:54 am

Thanks Xavier,

Disabling it and setting the cron job seems to be a good solution.
Maybe eZ Systems can put a comment on the ezfind.ini talking about this.

Regards.

Jon Ramster

Tuesday 08 February 2011 8:03:00 am

Hello all

Sorry to add a reply to such an old thread, but we recently had the same problem. On Publishing the eZ Find Java process would max the CPU out for 25 seconds on a small site! We had no option but to disable this to get an acceptable speed...

Jon

Paul Borgermans

Tuesday 08 February 2011 11:47:30 am

Disabling optimize on commit is indeed something you should disable for any site that has more than a few hundres of objects (most do ;) )

You can set up a cron job that optimizes the index once a week or once a day. See the cronjobs directory in ezfind.

If commits are taking too long, consider using the commitWithin ini setting in eZ Find 2.3 (specifying a time that is 2x the average commmit time -- see the logs for that, tyoically i would recommend 5000, which is 5 secs). This is a bit like delayed indexing, but then handled by the backend Solr.

hth

Paul

eZ Publish, eZ Find, Solr expert consulting and training
http://twitter.com/paulborgermans

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing: Jan 18 2025 05:05:51
Script start
Timing: Jan 18 2025 05:05:51
Module start 'layout'
Timing: Jan 18 2025 05:05:51
Module start 'content'
Timing: Jan 18 2025 05:05:52
Module end 'content'
Timing: Jan 18 2025 05:05:52
Script end

Main resources:

Total runtime1.0963 sec
Peak memory usage4,096.0000 KB
Database Queries69

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0073 589.3047152.6563
Module start 'layout' 0.00730.0044 741.960939.5078
Module start 'content' 0.01171.0831 781.4688645.4141
Module end 'content' 1.09480.0015 1,426.882816.1016
Script end 1.0963  1,442.9844 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00340.3088160.0002
Check MTime0.00140.1294160.0001
Mysql Total
Database connection0.00150.138010.0015
Mysqli_queries1.032494.1631690.0150
Looping result0.00070.0634670.0000
Template Total1.054996.220.5274
Template load0.00200.182220.0010
Template processing1.052996.032620.5264
Template load and register function0.00020.013810.0002
states
state_id_array0.00150.137210.0015
state_identifier_array0.00200.185120.0010
Override
Cache load0.00170.1542340.0000
Sytem overhead
Fetch class attribute can translate value0.00060.050340.0001
Fetch class attribute name0.00190.175280.0002
XML
Image XML parsing0.00300.275240.0008
class_abstraction
Instantiating content class attribute0.00000.001580.0000
General
dbfile0.00240.2216290.0001
String conversion0.00000.001040.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
5content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
7content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
3content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
2content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_pagelayout.tplEdit templateOverride template
 Number of times templates used: 19
 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs