[support] Optimizing Drupal6 + finding bottlenecks

[Joel Willers]

There are many things that can be done to optimize sites, including Drupal sites.  Incorrectly configured modules, poor programming, poor module interaction, slow MYSQL server (or unoptimized).  

I used Godaddy as my host for a while, but they had horribly slow Drupal sites (other sites were fine).  When I switched to BlueHost, all my performance issues vanished.  I hope that helps some.

Joel 

From: support-bounces at drupal.org [mailto:support-bounces at drupal.org] On Behalf Of robert mena
Sent: Sunday, July 24, 2011 7:49 PM
To: support at drupal.org
Subject: [support] Optimizing Drupal6 + finding bottlenecks

Hi,

I have a drupal6 website that is behaving strangely with some occasional slowdowns.

Any tips while trying to identify why it is like that?

I am ruling out hardware problems or even access since other sites (not drupal based) are hosted and does not behave like that.

Under admin/reports/dblog I see lots of messages such as 

Warning: Invalid argument supplied for foreach() in webform_phone_form_alter() (line 38 of//public_html/drupal/sites/all/modules/webform_phone/webform_phone.module).

or 

User warning: Duplicate entry 'admin/content/node-type/news/fields/field_embed_others_video' for key 1 query: INSERT INTO menu_router (path, load_functions, to_arg_functions, access_callback, access_arguments, page_callback, page_arguments, fit, number_parts, tab_parent, tab_root, title, title_callback, title_arguments, type, block_callback, description, position, weight, file) VALUES ('admin/content/node-type/news/fields/field_embed_others_videos', '', '', 'user_access', 'a:1:{i:0;s:24:\"administer content types\";}', 'drupal_get_form', 'a:3:{i:0;s:23:\"content_field_edit_form\";i:1;s:8:\"news\";i:2;s:25:\"field_embed_others_videos\";}', 63, 6, 'admin/content/node-type/news/fields', 'admin/content/node-type/news', 'Embed video', 't', '', 128, '', '', '', 0, 'sites/all/modules/cck/includes/content.admin.inc') in _db_query() (line 136 of/public_html/drupal/includes/database.mysql.inc).