Why Drupal.org is slow: New forum topic block and next/previous forum topic links

Events happening in the community are now at Drupal community events on www.drupal.org.
Amazon's picture
Posted by Amazon on July 21, 2007 at 4:53am

We are doing some slow query analysis. Turns out the database is reporting over 100 hours of slow queries due to just two features.

New forum topic block, and next/ previous forum topic links.

Comments

Disable it!

Posted by ablemike on July 24, 2007 at 5:06am
ablemike's picture

Is their evidence it's used in a way that no other solution could solve?

--
Define Discover Design Deploy
Mike Bishop - St. Louis Missouri

--
Define Design Develop Deploy!
Mike Bishop - St. Louis MO, USA

Does anyone use the

Posted by bradlis7 on October 22, 2007 at 4:52pm
bradlis7's picture

Does anyone use the previous/next topic links in the forum? I know I don't.

bradlis7.com | churchofchristnet.net

While the "Recent Posts" block is a nice feature

Posted by bonobo on October 22, 2007 at 6:52pm
bonobo's picture

I've often wondered about the next/previous links -- I'd be curious to see what kind of performance improvement could be gained by pulling that functionality --

Cheers,

Bill

FunnyMonkey
Tools for Teachers

FunnyMonkey

next/previous could

Posted by catch on October 23, 2007 at 3:20pm
catch's picture

next/previous could definitely be pulled - loads of people stick an empty .tpl.php file in their theme to get rid of them anyway.

Main issue for improving the performance of the queries is here: http://drupal.org/node/145353 which is blocked by: http://drupal.org/node/148849