By NeoID on

Drupal.org, I'm desperate... the last couple of days I've tried to figure out why only Drupal is such a memory hog on my system. I did a lot of research, profiling and such and fixed a lot of things on my servers configuration (lighttpd, fast-cgi, xcache, mysqli). However, as you can see.. my mysql query are few and fast, I have only a few (well known) modules as cck and views.. but still.. the page execution is so much higher...

This is on local host... I've tried with several different settings, but I can't find anything that works well.
If I don't find the problem I won't be able to use Drupal for my feature work, personal site or business, so hope anyone here does know what I could look for.

Devel:
"Executed 59 queries in 18.74 milliseconds. Page execution time was 670 ms."

⋅ Categories: Drupal 6.x

Comments

vm’s picture

vm commented

is page caching enabled? administer -> performance
is css aggregation enabled? adminsiter -> performance
is js aggregation enabled ? administer -> performance

Have you tried boost.module?

NeoID’s picture

NeoID commented

no, currently I've deactivated the cache in admin/performance.

As far as I know Boost doesn't help much for logged in users, so no, not tried it.

jon nunan’s picture

jon nunan commented

What OS and software are you using?

What kind of profiling did you do? Was it of Drupal itself, if so which functions were taking up the most amount of time? For some reason on my windows machine using an XAMPP windows setup I get times like yours, but on a Virtual Machine running Ubuntu on the same hardware Drupal is much faster. I haven't tracked the real reason down yet, but I suspect file scans/reading on some configurations is strangely slow.

arhak’s picture

arhak commented

if you're on a localhost dev environment try disabling the update module (or clear the checkbox on the last installation step)
if your site can't access the web (outgoing requests) every page load will be terrible slow

OTOH if using poormanscron be careful with search indexing (to detect this just disable search module or do some search on this site)

NeoID’s picture

NeoID commented

The execution time I wrote in my first post was from localhost on Windows 7 (wampserver), but I get the same results on my VPS (running arch linux, has 300MB Ram and software like listed in first post).
While the devel output in my first post was from a clean install, I usually use these modules with Garland.... Here's a list of the modules, time it consume and total time that has passed:
http://pastebin.com/m701b4e5c

The result is that mysql uses ~100ms, the modules ~300ms... and the final page execution ends with somewhat between 2000-8000ms.

I used PhpED, but I don't feel much smarter after using it: http://img199.imageshack.us/img199/4301/46071509.png
These part are the worst:
file.inc

 * Finds all files that match a given mask in a given directory.
 * Directories and files beginning with a period are excluded; this
 * prevents hidden files and directories (such as SVN working directories)
 * from being scanned.

...and...theme.inc

          if (function_exists($prefix .'_preprocess_'. $hook)) {
            $info['preprocess functions'][] = $prefix .'_preprocess_'. $hook;
          }

@arhak, I've tried that too, without any huge gain in performance :/