By ruturajv on

Hi,
I'm a very happy and satisfied user of drupal.org Ruturaj's Home Page

I want to ask the devs, that what is the number of url_aliases that I can create..

Cause from what I have seen in the code, it seems that drupal picks up all the url_aliases and stores in the memory, and uses it as and whenever it wants

So if my site increases to say 1000 nodes or more, and each having a distinct url_alias, could it lead drupal to run slow or something ?

⋅ Categories: Drupal 4.6.x

Comments

nevets’s picture

nevets commented

Yes, drupal can handle that. Check out www.poopreport.com, it has almost 3000 nodes and something over 4000 aliases

ruturajv’s picture

ruturajv commented

that is cool,
i have no problems then
Find me @ http://www.ruturaj.net/

yelvington’s picture

yelvington commented

Path aliases are stored in the database, not in memory.

There is a small performance penalty associated with path aliases, but it is inconsequential for most sites.

bryan kennedy’s picture

bryan kennedy commented

Well, I haven't done all my sluething work yet, but path aliases are my biggest DB hit right now. We are having problems with our DB bogging down with too many connections so I am trying to suss out the slowest DB querries with the devel module. And the 

SELECT * FROM url_alias

query is my slowest and is run on ever page. I need to figure out how I can speed this up. Then again, I am no DB expert and I might be mis-identifying our problem. Some new hardware will help for sure also.

Wish me luck.

Geary’s picture

Geary commented

You are right about the problem. If you can hang in there for a while, 4.7 fixes it.

Compare these:

http://drupaldocs.org/api/4.6/function/drupal_get_path_alias
http://drupaldocs.org/api/4.6/function/drupal_get_path_map

with these:

http://drupaldocs.org/api/head/function/drupal_get_path_alias
http://drupaldocs.org/api/head/function/drupal_lookup_path

bryan kennedy’s picture

bryan kennedy commented

Great, I just did an install with the new 4.7 beta and ran the devel mosule andsaw that this hapens differently. Now I just need to try out 4.7 on a copy of my production site. Thanks for the links.

bk