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.

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 31 2025 01:18:43
Script start
Timing:	Jan 31 2025 01:18:43
Module start 'layout'
Timing:	Jan 31 2025 01:18:43
Module start 'content'
Timing:	Jan 31 2025 01:18:43
Module end 'content'
Timing:	Jan 31 2025 01:18:43
Script end

Main resources:

Total runtime	0.0223 sec
Peak memory usage	6,144.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0041	588.3828	151.2422
Module start 'layout'	0.0042	0.0034	739.6250	220.7500
Module start 'content'	0.0075	0.0135	960.3750	997.8672
Module end 'content'	0.0210	0.0013	1,958.2422	29.9922
Script end	0.0223		1,988.2344

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0023	10.1819	14	0.0002
Check MTime	0.0010	4.3235	14	0.0001
Mysql Total
Database connection	0.0007	3.0580	1	0.0007
Mysqli_queries	0.0024	10.8703	3	0.0008
Looping result	0.0000	0.0406	1	0.0000
Template Total	0.0009	3.9	1	0.0009
Template load	0.0007	2.9319	1	0.0007
Template processing	0.0002	0.9780	1	0.0002
Override
Cache load	0.0004	2.0127	1	0.0004
General
dbfile	0.0029	12.9984	8	0.0004
String conversion	0.0000	0.0224	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs