Closed (fixed)
Project:
Pathauto
Version:
5.x-2.0
Component:
Code
Priority:
Normal
Category:
Support request
Assigned:
Unassigned
Reporter:
Created:
5 Dec 2007 at 11:44 UTC
Updated:
11 Feb 2008 at 12:49 UTC
when I try to bulk update many nodes... it takes a while and finally a "Page not found" appears... and the paths are not updated... so I guess it may be a limitation in php execution time or something.... is there a way to limit bulk update to x number of nodes ? and resend the bulk update again later?
thanks
Comments
Comment #1
gregglesHow many nodes do you have? What is your setting for "Maximum number of objects to alias in a bulk update: "?
Comment #2
hedac commentedoh... the option I was requesting was there...... the maximum number of objects to alias.... but it is at 50.... I think it is not too much... I will have to try less... but I have thousands of nodes to update... can be a pain...
Comment #3
hedac commentedI changed to 5 nodes maximum...
Bulk generation of nodes completed, 5 aliases generated.
this is what happened.... and what devel say:
Page execution time was 111803.52 ms. Executed 12970 queries in 107556.35 milliseconds
sooo slow... is it really necessary 12970 queries to add 5 nodes in bulk update? I think something is wrong...
Comment #4
gregglesThat is quite strange.
Can you list the contributed modules you have installed? What are your content types like? Do you make a lot of use of cck content types with lots of fields?
Also, can you do two more tests:
1. set the nodes to update to 0. Then run it. This will give us a baseline for the number of queries that happen when no nodes are updated.
2. Set the nodes to update to 1. Run bulk update again. This will let us know how many queries are required to alias one node.
Comment #5
hedac commentedthanks...
I don't think I have many modules installed.. but the wort of them in load terms.. is the internationalization module to translate content and locale module... those eat mysql queries...
I have 8 node types to bulk update... 5 of them CCK types.
all of them using the pattern 'xxxxx/[title-raw]' different xxx for each type
with 0 maximum:
Bulk generation of nodes completed, 0 aliases generated.
Page execution time was 22336.42 ms. Executed 4095 queries in 20947.27 milliseconds.
with 1 maximum:
Bulk generation of nodes completed, one alias generated.
Page execution time was 58780.8 ms. Executed 6262 queries in 57004.12 milliseconds.
:/ there were 19 guest in the site at the moment... but the thing is that it makes a lot of queries to put 1 alias... I know my database server is slow... but could it be so slow ?
Comment #6
gregglesWell, it would be interesting if you could set up a test site and then disable some modules and run the bulk update for 1 node again. That way you could see exactly where this problem arises.
For reference on my test site which has a random assortment of modules enabled I collected these numbers.
with 0 maximum:
Executed 254 queries in 566.25 milliseconds.
with 1 maximum:
Executed 271 queries in 896.73 milliseconds.
So, I believe that this is a problem that is more specific to certain situations and combinations of modules and not to Pathauto/Token in general. That said, I'm still interested in finding some way to fixi this.
Comment #7
gregglesThis is the only path to finding the root of the problem.
Unless you want to help fund Token2.0 development which will include a solution to this as well, I'll need to understand better what is happening on your site.
Comment #8
gregglesActive needs more info for a long time -> closing.
I understand the general problem (and the right people have it on their todo lists) but I can't fix the specific problem without data.