Overhead Database! WordPress

Abdelhadi Touil answers:

Hi.
I think it'll be better to have access to your website dashboard to have a look and optimize your website. For webhosting I think Hostgator is good.
Good luck.

Gabriel Reguly answers:

Hi,

1. Give a try with either http://wp-engine.com or http://rocketprezz.com.br

2. Please, install http://wordpress.org/extend/plugins/p3-profiler/ and tell the results.

Regards,
Gabriel

---

Plugarized answers:

Hola

Creo que lo mejor seria un Content Delivery Network (CDN)

Por otro lado podrias reducir los database request si usas el absolute path de ciertos archivos como por ejemplo en tu header


<link rel="alternate" type="application/rss+xml" title="<?php bloginfo('name'); ?> RSS Feed" href="http://www.holapolitica.com/feed/" />
<link rel="pingback" href="<?php bloginfo('pingback_url'); ?>" />
<link rel="stylesheet" type="text/css" href="<?php bloginfo('stylesheet_url'); ?>" media="screen" />
<link rel="stylesheet" href="<?php bloginfo('template_url'); ?>/css/dropdown.css" type="text/css" media="screen" />
<!--[if IE 6]><link rel="stylesheet" type="text/css" href="<?php bloginfo('stylesheet_directory'); ?>/css/ie6.css" /><![endif]-->
<!--[if IE 7 ]><link rel="stylesheet" type="text/css" href="<?php bloginfo('stylesheet_directory'); ?>/css/ie7.css" /><![endif]-->

<strong>remplazas el <?php bloginfo('stylesheet_directory'); ?> por la direccion absoluta</strong>

<link rel="alternate" type="application/rss+xml" title="Hola Política RSS Feed" href="http://www.holapolitica.com/feed/" />
<link rel="pingback" href="http://www.holapolitica.com/xmlrpc.php" />
<link rel="stylesheet" type="text/css" href="http://www.holapolitica.com/wp-content/themes/holapolitica/style.css" media="screen" />
<link rel="stylesheet" href="http://www.holapolitica.com/wp-content/themes/holapolitica/css/dropdown.css" type="text/css" media="screen" />
<!--[if IE 6]><link rel="stylesheet" type="text/css" href="http://www.holapolitica.com/wp-content/themes/holapolitica/css/ie6.css" /><![endif]-->
<!--[if IE 7 ]><link rel="stylesheet" type="text/css" href="http://www.holapolitica.com/wp-content/themes/holapolitica/css/ie7.css" /><![endif]-->

Si utilizas la direccion absoluta en ves de hacer un request con <?php bloginfo('stylesheet_directory'); ?> te haorras varios mysql queries

De todas formas con el total cache que tienes eso convierte todas las paginas a html y tus usuarios van a ver una pagina cached en ves de php.

Pero lo mejor de todo seria un CDN

---

Francisco Javier Carazo Gil answers:

Hi,

If you are using a shared hosts, you cannot use advanced solutions like Varnish, that solve this problem perfectly, if you are in a VPS or dedicated, use it.

Well if we cannot use Varnish, you can act in two ways.

Firstly, do as LatinUnit says and substitute in your header.php all get_option by a static value. Yes, you can do it in every value that is always the same: rss url, charset, language, etc. In this same direction, install P3 Profiler and look if there is a special load from a plugin.

Secondly, install a cache. I recommend you http://wordpress.org/extend/plugins/wp-super-cache/ and configure it. The best option to be able to receive more visits with security, is the .htaccess one.

Finally, if after all this, you have more than 15k visits and you want to offer a good service, user Varnish, I can tell you how, I have clients with thousends of visits and no problem, it's like a SuperCache plugin but in a low level and you scale as much as you want using only a little server.

triben answers:

You are using awfully alot of query_posts. It creates a bunch of queries because it creates a new wp_object each time hence its costly in queries and plays with the main query. Use pre_get_posts in a function with transients (wordpress way o putting html directly in the database and getting it when needed, one query for the whole html of the list of posts per example). For examples use the link and follow at the end the code and modify for your own need. http://developer.wordpress.com/2012/05/14/querying-posts-without-query_posts/

---

MDan answers:

If you are reffering at what phpMyAdmin calls overhead, you may get rid of the overhead by running OPTIMIZE TABLE command that will compact your table and indexes.
See this for start: http://wpmu.org/wordpress-maintenance-101-how-to-optimize-and-repair-database-tables/
Also a good post on Overhead: http://www.inforats.com/optimize-your-mysql-database-clear-overhead/

Make a BACKUP before doing any changes!

Jarret Minkler answers:

Don't waste your $$ to get a VPS, all you will do is run slow plugins on a faster server.

You need to figure out what is making the calls. Check http://wordpress.org/extend/plugins/debug-queries/

I usually do WP "speed ups" for @ $150 USD

---

---