I beleive pathauto really sucks server resources when a lot of nodes are in the database. It constantly queries the "path" table to find out where the real node is...

Why not add a option in pathauto where the node ID is included in the URL.

example path with the node ID included

http://example.com/123-my-super-seo-url
http://example.com/my-super-seo-url-123

I do that in some of my custom built sites like http://01wholesale.com and http://01motors.com/

The result is quicker access.

Comments

pamphile’s picture

pamphile commented

Here is a situation where pathauto might have problems
http://drupal.org/node/38415

mikeryan’s picture

mikeryan
he/him
Primary language English
Location Pittsfield, MA, USA
commented
Priority: Critical » Normal
Status: Active » Closed (won't fix)

Pathauto already supports [nid] to insert node IDs in the path.

FYI, the performance problem with many aliases is fixed for 4.7, and there are patches available for 4.6.

venkat-rk’s picture

venkat-rk commented

Could you please point me to the patches for 4.6? I couldn't locate them in the issues listing.

mikeryan’s picture

mikeryan
he/him
Primary language English
Location Pittsfield, MA, USA
commented

At http://drupal.org/node/22035, comment #8 has my original patch, and down at #31 you can find the approach that was integrated into 4.7.