By lococtupento on

I run a drupal 5.2 site with about 4000 nodes, standard caching is enabled,
and few additional modules: ad (caching enabled), poormanscron, xmlsitemap, Pathauto, Spam, Article.
Every time a spider visits my site or I work on the content i see the message: "User 'tirizio1' has exceeded the 'max_questions' resource (current value: 50000)"
Is there a way to reduce database load?

⋅ Categories: Drupal 5.x

Comments

panis’s picture

panis commented

it can be resource intensive for sites with large number of nodes. Disable it for a few days and see if you get the same response from robots etc. I had a similar problem with 30000 nodes. if you do - look at the sitemap module issues page - I had posted suggestions for how to fix it. If not been fixed I can send you my patched module.

The other area is categories and taxonomy if you have it enabled and have many categories. I have about 3000 categories - need to keep track of Country->State->City level hierarchy. The directory module can be a resource hog with nested sql queries etc - that just about brought my site down by itself until I changed it.

lococtupento’s picture

lococtupento commented

I'm testing your patch for the xmlsitemap module but it does not reduce the database load, I've just found that event repeat module was set with a 1000 day render support I reduced it to 90 now. I hope it works.