Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By newbuntu on
I have drupal 5.6 and 5.10 running on my localhost with many modules enabled.
Now I installed 6.4 on my local machine. I haven't enabled any modules yet. I noticed that just visiting "site building=>modules" (admin/build/modules) takes 4 seconds to load. I could hear the hard drive was running like crazy when clicked the link. If I go to the same link on the 5.x versions, it takes less than 1 second to load.
All of these happen are running the same local machine. It worries me that this may indicate a huge performance problem with 6.4.
I also noticed that drupal 6.4 db install process took several times longer than 5.x install time.
Any insight is greatly appreciated!
Comments
Drupal 6.4 - no performance issues here ...
I haven't noticed any performance issues with Drupal 6.4 (as opposed to 5.x). I have multiple 6.4 sites running in a production environment. My Drupal 6.4 sites appear to run speedier that my 5.x sites. Additionally it doesn't strike me that a 4 second module admin load is a performance issue. This seems normal.
You may want to check your localhost PHP settings. This lag could also be due to just running it in your localhost environment.
Also, have you checked your status report via Drupal admin?
-backdrifting
Thanks for sharing your
Thanks for sharing your information.
I checked the status report didn't see anything significant. (in fact, hardly anything logged there).
I tried to enable a few modules, now the admin/build/modules link takes more than 10 seconds long to show up. On the same machine, i tried previous versions, they all came up almost instantaneously.
Just for sanity check, I clicked all other admin links, they all seem to be faster than 5.x. Only admin/build/modules takes forever.
What modules do you use for your production site? I am trying to install og (organic group). It pulled out a bunch of modules that are in beta and alpha states.
It is a dilemma for me if I should move on to 6.x. I was facing that decision a year ago, I thought it would be no brainer by now, but it still doesn't look good :(
It's pretty fast for me
A new setup on a remote server, it comes up in about 1 sec for me.
But as I add more modules, it gets progressively slower. I understand this is to be expected because this page visits every installed modules whether it's enable or not.
It's definitely a problem in
It's definitely a problem in my case. If anyone else experiences similar problem, then it may be a real issue.
I tried to re-install it several times, and used clock to time the load time. It actually took about 20 sec to load admin/build/module page. Beats me, I don't know where the problem is.
Many have found that
Many have found that disabling Update in Drupal 6 improves performances on localhosts.
I dumped out the data using Devel module
I found out where it's sucking the time. I installed devel module, dumped out the data.
Can anyone tell what's wrong?
Executed 1478 queries in 24852.78 milliseconds. Queries taking longer than 5 ms and queries executed more than once, are highlighted.
ms # where query
265.38 1 _menu_router_build INSERT INTO menu_router (path, load_functions,
168.68 1 _menu_router_build INSERT INTO menu_router (path, load_functions,
158.62 3 _menu_update_parental_status UPDATE menu_links SET has_children = 0 WHERE m
113.33 2 module_rebuild_cache UPDATE system SET info = 'a:10:{s:4:\"name\";s
104.47 1 cache_set INSERT INTO cache_views (cid, data, created, e
103.41 8 _menu_update_parental_status UPDATE menu_links SET has_children = 1 WHERE m
92.95 1 menu_link_save UPDATE menu_links SET menu_name = 'navigation'
91.83 2 cache_clear_all DELETE FROM cache_menu WHERE cid LIKE 'links:n
88.14 1 menu_link_save UPDATE menu_links SET menu_name = 'navigation'
80.31 1 menu_link_save UPDATE menu_links SET menu_name = 'navigation'
79.44 1 _menu_router_build INSERT INTO menu_router (path, load_functions,
77.43 8 _menu_update_parental_status SELECT mlid FROM menu_links WHERE menu_name =
76.86 1 _menu_router_build DELETE FROM menu_router
76.17 1 _menu_router_build INSERT INTO menu_router (path, load_functions,
73.7 1 _menu_router_build INSERT INTO menu_router (path, load_functions,
70.67 1 _menu_router_build INSERT INTO menu_router (path, load_functions,
The data is too long. I have
The data is too long. I have to cut the data, otherwise the forum won't show it.
I can post the whole dumped out data on a server, if it helps someone to diagnose the problem. Pls let me know.
The dump is generated when admin/build/modules link is clicked.
5.10 is 20 times faster
By comparison, on the same machine, I dumped out 5.10 admin/build/modules. It's 20 times faster!!! Both are brand new install.
Executed 44 queries in 1238.72 milliseconds. Queries taking longer than 5 ms and queries executed more than once, are highlighted.
ms # where query
59.37 1 sess_write UPDATE users SET access = 1222058857 WHERE uid = 1
54.7 1 sess_write UPDATE sessions SET uid = 1, cache = 0,
47.95 1 module_rebuild_cache UPDATE system SET description = 'Logs and records system events.',
42.49 1 module_rebuild_cache UPDATE system SET description = 'Aggregates syndicated content (
40.04 1 module_rebuild_cache UPDATE system SET description = 'Lets you register your site with a ce
39.81 1 module_rebuild_cache UPDATE system SET description = 'Allows the user to change
...
Exactly!
Exactly that is also my observation. There's some consolation in knowing I'm not alone.
Here's the funny bit: I copied the entire install from my company's laptop to my home PC (both Windows XP) by doing a byte-by-byte copy of everything including PHP, Apache and MySQL. So all the versions, executables, config, DB etc. etc. are identical on both.
Started the servers on both machines; the page times out after 30secs on the laptop, whereas loading the exact same page is like a breeze on the home PC... Hardwarespecs are pretty much the same (1GB ram; everything fits in physical mem on both, respective CPUs are not any near 100% ever, both on the same network and running localhost).
The differences I observed:
- Home PC is on SP1, laptop is SP2
- Home PC uses Firefox 2, laptop is on Firefox 3
Furthermore: I'm using virtualhosts on apache and have got PDT with Zend's debugger installed (tho not running and loading the pages directly via the browser).
Curiously enough, devel.module doesn't trap the db log on the modules list on my home PC but works anywhere else. It running is not part of the problem tho. I downloaded and installed it because of this issue.
Someone who's more into this subject: is this triggering any of your thoughts?
BTW.: _menu_router_build is just one element in the total overhaul of the menus in D6's. Comparing D5 with D6 at this point is void; I use a completely fresh installation of WAMP and D6 and already then I'm facing the issue.
I opened an issue
I opened an issue http://drupal.org/node/311626, so far, no one has responded yet.
The huge contrast is that 6.x "Executed 1478 queries in 24852.78 milliseconds", and 5.x only used "44 queries".
It appears to me that only "admin/build/modules" causes this huge discrepancy.
I'm also testing on my laptop. I am running XP sp2, apache 2.2, php5.2.6, mysql 5.1.
slow Drupal 6.4
Hi,
I have the same problem in localhost. The Drupal 6.4 is much slower then Drupal5.10 , the loading modules takes forever! I don't know where is the problem and if I should develop a site using Drupal 6.4? I tent to use a lot of modules in a single site. If you have solve this problem, could you share me it?
Thanks
Mai Thuan
In the spirit of "spread the
In the spirit of "spread the wealth", I am sharing my solution for my problem, hope it may help you as well.
See #22 in this post http://drupal.org/node/311626