By Jeff Burnz on

This page has been getting slower and slower for quite a while, can anyone shed some some light on how I might be able to speed it up ?

It takes minutes to load and is driving us all nuts.

There's around 35000 nodes all with alias's, 40 000 odd terms if that makes a difference. Most of the content (99.999%) is a very simple CCK type that originated in 4.7, but the site was upgraded to 5.1 recently, though the slowness pre-dates the upgrade.

Each day we publish around 50 - 60 new nodes so we need to able to use even the most rudimentary content management tools, but this is becoming impossible. The rest of the site is blazing fast (we're running on Lighttpd & lots of RAM etc).

It's just absurd, using any of the sorting tools has become a 'go and make a coffee' sort of affair...

Thoughts?

⋅ Categories: Drupal 5.x

Comments

Jeff Burnz’s picture

Jeff Burnz commented

Where should I look to disable a particular vocab from loading in the 'category' options list, we have one that is monster huge, that's probably it now I think about it for a minute...

Pimp your Drupal 8 Toolbar - make it badass.
Adaptivetheme - theming system for people who don't code.
vm’s picture

vm commented

my suggestion is to install the devel.module to run some tests. find your slow querries, find out what is going on in more detail rather then stabbing at it in the dark. The 35000 path aliases can be a killer too from what I've read read in the performance threads.

Jeff Burnz’s picture

Jeff Burnz commented

yea, normally I would but Devel is not outputting to screen for some reason in this site, ever since we moved to D5 is stopped working, so I should probably fix that also... but really, the giant options list under categories would be slowing this page down a lot

Pimp your Drupal 8 Toolbar - make it badass.
Adaptivetheme - theming system for people who don't code.
Jeff Burnz’s picture

Jeff Burnz commented

Simply commenting out a few lines in node.module did the trick, instant fix, now our admin/content/node page is blazing fast like all the others - yay! However, this of course entailed a minor hack to a core module, so will have to rectify that at some later stage...

1333  // The taxonomy filter
1334  //if ($taxonomy = module_invoke('taxonomy', 'form_all', 1)) {
1335  //  $filters['category'] = array('title' => t('category'), 'options' => $taxonomy);
1336  //}
Pimp your Drupal 8 Toolbar - make it badass.
Adaptivetheme - theming system for people who don't code.