Domas Mituzas exposes our database queries and their not-so-white under-garments. Optimizing our queries is long overdue. Although several of the performance issues Domas points out are already fixed in either 2.0 or the ongoing 2.1 development, most are still lingering and need to be addressed. After having a nice chat with Domas on IRC, we opened a bug to track the implementation of his suggestions. Even the small changes we've committed so far provide notable performance improvements. Combined with the performance work already underway, these suggestions result in WP performing faster at a lower system load. More bits served with less work. Thanks Domas.
It was honestly heartwarming to watch the back-and-forth between Domas and Matt regarding this stuff in #wordpress. Every couple of minutes Domas had another suggestion for speeding things up and Matt was right there, checking things out and making sure it didn’t break WP’s BC. (though I get the impression MySQL
The above comment was chewed by an unencoded < should end with:
(though I get the impression MySQL < 4 will no longer be supported as of WP2.1… ’bout time!
and I thought it was my web host’s mysql server. haha Thx guys.
[...] But this is damn interesting. Hell I always found even Postnuke beats the shit out of WordPress in a matter of db-management. Don’t ask me why or how, but it damn does. WP is fucking slow. Having found the link to this artikel here at boren.nu I wonder what expects us for WP2.1. If those changes will immediately be integrated, together with some smaller tweaks for the speed optimization I think WP might immediately jump to 2.5 instead of 2.1. Somehow I am skerred. Still learning to find my way through WP, just using it since less than a month, and those changes coming now. Bummer I just wanted to start playing with WP. I better wait a little longer and see what comes. I guess the category EE will stay quite empty for a little longer. [...]
[...] Its SQL badly needs some optimization. The devs are aware of this and help is underway. Might take a little time, of course… [...]
Will this be backported to WP 1.5.x ?
It would be really nice to benefit from these enhancements.
[...] But this may speed things up a bit. It seems that WordPress underwent some criticism lately for using under-optimized database code. And, like a true OSS program, the WordPress team is now planning to speed things up a bit. [...]
[...] De acuerdo a un artículo de Ryan Boren publicado el lunes en su weblog, el equipo de desarrollo de WordPress se encontraría trabajando en optimizar las consultas que éste realiza a la base de datos: algunas mejoras ya vienen implementadas en la versión “2.0″ o la actualmente en desarrollo 2.1, mientras que otras (la mayoría, de acuerdo a Boren) serán implementadas gracias a las sugerencias de Domas Mituzas. [...]
[...] WordPress mas rapido De acuerdo a un artículo de Ryan Boren publicado el lunes en su weblog, el equipo de desarrollo de Free blog tool and weblog platform” href=”http://wordpress.org/”>WordPress se encontraría trabajando en optimizar las consultas que éste realiza a la base de datos: algunas mejoras ya vienen implementadas en la versión “2.0″ o la actualmente en desarrollo 2.1, mientras que otras (la mayoría, de acuerdo a Boren) serán implementadas gracias a las sugerencias de Domas Mituzas. [...]
[...] I think more such reviews are required as they can substantially improve the product, eventually benefiting all of us. Ryan Boren has acknowledged this and has said that some of the suggestions have been implemented and some are being tracked. I think some redesign of the database will be required to optimize it. [...]
[...] But this is damn interesting. Hell I always found even Postnuke beats the shit out of WordPress in a matter of db-management. Don’t ask me why or how, but it damn does. WP is fucking slow. Having found the link to this artikel here at boren.nu I wonder what expects us for WP2.1. If those changes will immediately be integrated, together with some smaller tweaks for the speed optimization I think WP might immediately jump to 2.5 instead of 2.1. Somehow I am skerred. Still learning to find my way through WP, just using it since less than a month, and those changes coming now. Bummer I just wanted to start playing with WP. I better wait a little longer and see what comes. [...]
[...] El equipo de WordPress trabaja en optimizar las consultas hechas a la base de datos, una noticia que alegrará no solo a quienes usamos su software, sino también a los administradores de nuestros servicios de alojamiento. De acuerdo a un artículo de Ryan Boren publicado el lunes en su weblog, el equipo de desarrollo de WordPress se encontraría trabajando en optimizar las consultas que éste realiza a la base de datos: algunas mejoras ya vienen implementadas en la versión “2.0? o la actualmente en desarrollo 2.1, mientras que otras (la mayoría, de acuerdo a Boren) serán implementadas gracias a las sugerencias de Domas Mituzas. [...]
[...] Blijkbaar een zwak punt van WordPress : http://boren.nu/archives/2006/04/03/romancing-the-database/#comments [...]
Optimización de WordPress en el roadmap…
Según se puede leer en una entrada en Yukei.net titulada: WordPress: más rápido y con menos trabajo:
De acuerdo a un artículo de Ryan Boren publicado el lunes en su weblog, el equipo de desarrollo de WordPress se encontraría trabajando en opti…
I love reading things like this, gives me more confidence in my blogging software of choice. Thank you!
[...] as they can substantially improve the product, eventually benefiting all of us. Ryan Boren has acknowledged this and has said that some of the suggestions have been implemented and some are being tracked. I [...]