soydemadrid

Hi just an update to this.

All the sites run Wordfence, and when comparing all the settings screens there does seem to be more firewall rules in place for the slow site (an option I can’t see how to adjust in the free version), so I believe it is Wordfence that is crippling things. If i completely disable Wordfence and delete the plugin the site then does load quicker, so I’ve posted for help here on their support forum:

https://wordpress.org/support/topic/excruciatingly-slow-website-performance/

Thanks once again for helping diagnose this.

Hi thanks for the replies.

I’ve tried also disabling the theme now too, but this also makes no difference. The WordPress backend is equally as slow as the frontend…

Is there anything that can cause a site to slow like this in WordPress such as missing files, mysql issue etc?

Thanks again.

Here is the code throwing up the issue:

/***************************************************************/
/*	Menu Descriptions				  						   */
/***************************************************************/

function DYN_page_lists($output) {
	global $wpdb;

	$get_MenuDesc = mysql_query("SELECT p.ID, p.post_title, p.guid, p.post_parent, pm.meta_value FROM " . $wpdb->posts . " AS p LEFT JOIN (SELECT post_id, meta_value FROM " . $wpdb->postmeta . " AS ipm WHERE meta_key = 'pgopts') AS pm ON p.ID = pm.post_id WHERE p.post_type = 'page' AND p.post_status = 'publish' ORDER BY p.menu_order ASC");
	while ($row = mysql_fetch_assoc($get_MenuDesc)) {
			extract($row);
			$post_title = wptexturize($post_title);
			$data = maybe_unserialize(get_post_meta( $ID, 'pgopts', true ));		

			$menudesc=$data["menudesc"];		

			if($menudesc!="") {
			$output = str_replace('>' . $post_title .'</a>' , '>' . $post_title . '</a><span class="menudesc">' . $data["menudesc"] . '</span>', $output);
			}

		}	

			$parts = preg_split('/(<ul|<li|<\/ul>)/',$output,null,PREG_SPLIT_DELIM_CAPTURE);
			$insert = '<li class="menubreak"></li>';
			$newmenu = '';
			$level = 0;
			foreach ($parts as $part) {
			if ('<ul' == $part) {++$level; }
			if ('</ul>' == $part) {--$level;}
			if ('<li' == $part && $level == 0) {$newmenu .= $insert;}
			if ('</ul>' == $part && $level == 1) {$newmenu .= $insert_a;}
			$newmenu .= $part;
			}

	return $newmenu;
}