|
Florent Massiera
|
Monday 04 December 2006 7:56:16 am
Hello,
I'm using a crontab to make huge xml imports in ez.
My problem is the execution of the program called by the cron seems to stop randomly after a while.
Here is my command line :
php runcronjobs.php -d importXMLData
At the end, here is what I have (but the file was not entirely imported) :
Notice: (eZMySQLDB::query(0.000 ms) query number per page:0)
SET NAMES 'utf8'
Timing: ()
Script extension/importData/cronjobs/importXML.php starting
Script extension/importData/cronjobs/importXML.php starting 0.0000 sec
Total runtime: 921.3177 sec
Group ini_load:
Load cache: 1.4332 sec (0.1554%), 0.1194 avg sec (12)
FindInputFiles: 0.0170 sec (0.0018%), 0.0014 avg sec (12)
Parse: 1.2140 sec (0.1316%), 0.2023 avg sec (6)
Save Cache: 0.0898 sec (0.0097%), 0.0150 avg sec (6)
Group Mysql Total:
Mysql_queries: 338.1341 sec (36.6544%), 0.0013 avg sec (262748)
Looping result: 11.3984 sec (1.2356%), 0.0001 avg sec (138999)
Group TS translator:
TS init: 14.6806 sec (1.5914%), 14.6806 avg sec (1)
TS load: 3.5356 sec (0.3833%), 1.7678 avg sec (2)
TS store cache: 11.1394 sec (1.2075%), 11.1394 avg sec (1)
Group class_abstraction:
Instantiating content class attribute: 24.6982 sec (2.6773%), 0.0002 avg sec (126195)
Group Sytem overhead:
Fetch class attribute can translate value: 0.6301 sec (0.0683%), 0.0003 avg sec (2384)
Group XML:
Image XML parsing: 21.0355 sec (2.2803%), 0.0176 avg sec (1192)
Group :
Check cache: 52.2444 sec (5.6634%), 0.0439 avg sec (1191)
Node cleanup: 15.4991 sec (1.6801%), 0.0130 avg sec (1191)
Generating view cache: 0.0861 sec (0.0093%), 0.0001 avg sec (1191)
Group Search Total:
remove object: 1.0318 sec (0.1118%), 0.0009 avg sec (1191)
add object: 198.9108 sec (21.5623%), 0.1670 avg sec (1191)
Group General:
INI string conversion: 0.9658 sec (0.1047%), 0.0402 avg sec (24)
String conversion: 13.7814 sec (1.4939%), 0.0002 avg sec (67412)
String conversion w/ codepage: 0.9596 sec (0.1040%), 0.0480 avg sec (20)
dbfile: 0.2867 sec (0.0311%), 0.0001 avg sec (2383)
String conversion w/ UTF-8 to Unicode: 1.7568 sec (0.1904%), 0.0001 avg sec (20247)
String conversion w/ Unicode to UTF8: 1.5309 sec (0.1659%), 0.0001 avg sec (20247)
Total script time: 922.4936 sec I hope someone can help me or giving me some clue about importing data in ez, in order to check all possibilities. Thank you all
|