Forums / Install & configuration / Upgrade from 3.9.0 to 3.10.1 and updateniceurls.php

Upgrade from 3.9.0 to 3.10.1 and updateniceurls.php

« 
Previous topic
|
Install & configuration
|
Next topic
 »
Author Message

Sébastien Antoniotti

Tuesday 19 May 2009 1:06:40 am

Hi,

I'm upgrading a large site from 3.8.4 to 4.1.1, and I'm actually at the 3.9.0=>3.10.1 upgrade step.

This site contains more than 30 000 nodes and the problem is that updateniceurls.php takes too much time : 20% at the last step (updateNodeAlias) after 10 hours of execution...

So my question is : if I don't want to change urls for this website, is there a way to hack updateniceurls.php in order to skip some parts of the script and reduce the execution time without corrupting the database ?

Thanks in advance !

eZ Publish Freelance
web : http://www.webaxis.fr

Gurudutt Verma

Saturday 23 May 2009 7:03:57 pm

Hi Sébastien,

If you want to use niceurl's then I don't see any other way to do it.

In your case it is recommended to execute updateniceurl.php script while you upgrade your site eZ Publish 3.10.x to eZ Publish 4.0.x(Latest version of eZ Publish 4.0.x)

About time consuming process,
Is your database and eZ Publish files are located at two different servers ?
OR
Are you executing this script at server where server load is too high ?
if this is the case then just try to copy your database to different faster machine and see if that helps.

Also try to clear ini cache first and then execute this script(updateniceurls.php), this will improve performance of this script.

eZ debug

Timing: Jan 30 2025 11:02:26
Script start
Timing: Jan 30 2025 11:02:26
Module start 'content'
Timing: Jan 30 2025 11:02:26
Module end 'content'
Timing: Jan 30 2025 11:02:26
Script end

Main resources:

Total runtime0.2202 sec
Peak memory usage8,192.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0093 588.1875370.2656
Module start 'content' 0.00930.0234 958.45311,001.6250
Module end 'content' 0.03270.1875 1,960.07813,890.0391
Script end 0.2202  5,850.1172 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00462.1056200.0002
Check MTime0.00140.6399200.0001
Mysql Total
Database connection0.00120.531410.0012
Mysqli_queries0.103647.03771410.0007
Looping result0.00130.59801390.0000
Template Total0.187084.910.1870
Template load0.00110.487310.0011
Template processing0.185984.406310.1859
Override
Cache load0.00070.304210.0007
Sytem overhead
Fetch class attribute can translate value0.00221.016310.0022
XML
Image XML parsing0.00030.145410.0003
General
dbfile0.01798.1194200.0009
String conversion0.00000.003430.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0002 secs